PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
During data directory initialization, MySQL creates user accounts that should be considered reserved: 'root'@'localhost: Used for administrative purposes. Strictly speaking, this account name is not reserved, in the sense that some installations ...
https://dev.mysql.com/doc/refman/5.7/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system database. When the read_only system variable is enabled, account-management statements require the SUPER privilege, in addition to any other required privileges. This database ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. The following table lists the types of mysql.user accounts considered in this ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
To use ALTER USER, you must have the global CREATE USER privilege or the UPDATE privilege for the mysql system database. It is also possible to specify CURRENT_USER or CURRENT_USER() to refer to the account associated with the current session. In ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
The default_authentication_plugin value affects these aspects of server operation: It determines which authentication plugin the server assigns to new accounts created by CREATE USER and GRANT statements that do not explicitly specify an ...The ...
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
Thereafter, you normally set up, modify, and remove MySQL accounts using statements such as CREATE USER, DROP USER, GRANT, and REVOKE. MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
Consider the following procedure, which displays a count of the number of MySQL accounts listed in the mysql.user system table: CREATE DEFINER = 'admin'@'localhost' PROCEDURE account_count() BEGIN SELECT 'Number of accounts:', COUNT(*) FROM ...The ...To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. In addition, setting max_user_connections does not enable management of individual accounts. An “account” in this context corresponds to a row ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). If ...For complete details on other possibilities, see Section 13.7.1.2, “CREATE USER Statement”, Section 13.7.1.1, “ALTER USER Statement”, Section 13.7.1.4, “GRANT Statement”, and Section 13.7.1.7, “SET PASSWORD ...
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
To set this up, create a MySQL account named sql_admin that uses the Windows plugin for authentication: CREATE USER sql_admin IDENTIFIED WITH authentication_windows AS 'Rafal, Tasha, Administrators, "Power Users"'; The plugin name is ...Using ...