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/faqs-mysql-cluster.html
MySQL NDB Cluster provides support for distributed privileges, which you can enable by following a procedure provided in the documentation; see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”, for more information. How do I ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
To upgrade these accounts to use mysql_native_password explicitly, execute these statements: UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE plugin = '' AND (Password = '' OR LENGTH(Password) = 41); FLUSH PRIVILEGES; Before MySQL 5.7, ... The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
Example: SELECT set_firewall_mode('fwuser@localhost', 'RECORDING'); Firewall Miscellaneous Functions These functions perform miscellaneous firewall operations: mysql_firewall_flush_status() This function resets several firewall status variables to ...Each mysql system database table is accessible only by accounts that have the SELECT privilege for ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list entries. Privileges Required to Access the Process List For most sources of ...The ...
https://dev.mysql.com/doc/refman/5.7/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. When the read_only system variable is enabled, RENAME USER additionally requires the SUPER privilege. RENAME USER causes the ... RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
The session user must have privileges sufficient to set restricted session variables. If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
You see only those databases for which you have some kind of privilege, unless you have the global SHOW DATABASES privilege. If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. In cases where you need to transfer databases between different architectures, you can use mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; FLUSH PRIVILEGES; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ FOR CHANNEL ...In this ... At this point, the group has one member in it, server s1, which has some data in ...