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/replication-features-user-names.html
The maximum length of MySQL user names was increased from 16 characters to 32 characters in MySQL 5.7.8. Replication of user names longer than 16 characters to a replica that supports only shorter user names fails. However, this should occur only ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
--user=user_name, -u user_name Command-Line Format --user=user_name, Type String The user name of the MySQL account to use for connecting to the server. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be ...SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current ...
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.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. ndb-connectstring=management_host[:port] ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 21.7.2, “General Requirements for NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--user=user_name, -u user_name Command-Line Format --user=user_name, Type String The user name of the MySQL account to use for connecting to the server. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
Commands for the event logs are given in Section 21.6.3, “Event Reports Generated in NDB Cluster”; commands for creating backups and restoring from them are provided in Section 21.6.8, “Online Backup of NDB Cluster”. CREATE NODEGROUP ... In ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
MySQL does not perform matching of Host column values in the mysql.user system table against host names for which one or more of the initial components of the name are entirely numeric, such as 1.2.example.com. For the rationale why this type of ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
For example, the following statement creates such an account, where password is the desired account password: CREATE USER 'sha2user'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password'; caching_sha2_password supports connections over ...