PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, which means that a user account and its associated privileges created on one SQL node are not available on the cluster's other SQL nodes. A ...This support is not enabled by default; you should follow the procedure outlined in this section in order to do ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
For views defined with the SQL SECURITY INVOKER characteristic, CURRENT_USER returns the account for the view's invoker. For information about user auditing within views, see Section 6.2.18, “SQL-Based Account Activity Auditing”. If the DEFINER ...For information about restrictions on view use, see Section 23.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and VERSION() functions have the UTF-8 character set by default. Thus column names, database names, user names, version ...This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ...Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
For additional options that can be set in my.cnf for replicas, see Section 16.1.6, “Replication and Binary Logging Options and Variables”. (See Section 16.2.1, “Replication Formats”.) In addition, we recommend enabling the ... Preparing the ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ...[group] group is the name of the program or group for which you want to set ...(For mysqld, use --verbose and --help.) If the program reads option files, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Account, host, and user statistics are not collected if the performance_schema_accounts_size, performance_schema_hosts_size, and performance_schema_users_size system variables, respectively, are set to 0. The Performance Schema supports TRUNCATE ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
Found wrong password for user 'some_user'@'some_host'; ignoring user As a result, the account is simply ignored by the permission system. Use mysql to update the account in the user table with a new password, making sure to use the PASSWORD() ... If ...Check whether the Password column of that table is shorter than 16 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Connection id: 1 Current database: test Query OK, 1 row affected (1.30 sec) mysql> SELECT * FROM t; +------+ | a | +------+ | NULL | +------+ 1 row in set (0.05 sec) The @a user variable has been lost with the connection, and after the reconnection ...However, even if mysql succeeds in reconnecting, your first connection has ended and all your previous session objects and settings are lost: temporary tables, the autocommit mode, and user-defined and session ...Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) ...