PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/alter-function.html
(That privilege is granted automatically to the function creator.) If binary logging is enabled, the ALTER FUNCTION statement might also require the SUPER privilege, as described in Section 23.7, “Stored Program Binary Logging”. ALTER FUNCTION ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
By default, that privilege is granted automatically to the procedure creator. This behavior can be changed by disabling the automatic_sp_privileges system variable. ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... This ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. The list of ... Once you know how to enter SQL statements, you are ready to access a ...