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/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. These examples assume that the MySQL root account has the CREATE USER privilege and all privileges that it grants to ...Another option for creating accounts is to use the GUI tool MySQL ...Note Direct modification of grant tables using statements such ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its plugin. Default Proxy User and Anonymous User Conflicts If you intend to create a default proxy user, check for other existing “match ...The account for the external proxy user must be set up to be authenticated by the ...The plugin that authenticates a given connection may request that the ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
(To associate an LDAP user DN with a MySQL account, include a BY clause that specifies an authentication string in the CREATE USER statement that creates the account.) If the MySQL account names no LDAP user DN, LDAP authentication uses the user ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
Specifically, do not permit User to be empty (which creates an anonymous-user account), and do not permit pattern characters or netmask notation in Host values. The User and Host column values in this row uniquely identify the account and correspond ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
In addition, you must name the PAM service in the authentication string of the CREATE USER statement for any account that authenticates using that PAM service. The server finds a matching MySQL account based on the external user name and the host ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. Account names appear in SQL statements such as CREATE USER, GRANT, and SET ...An account name consisting only of a user name is equivalent to ...This section describes the ...For string-quoting and ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege characteristics such as its password, whether it uses secure connections, and limits on access to server resources, then uses GRANT to define ...ALTER USER may be used to change the nonprivilege characteristics of existing ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; The host name part of the account name, if omitted, defaults to '%'. Mark the password expired so that the user must choose a new one at the first connection to the server: ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. The ...In the absence of either clause, the account is created in an unlocked ...For upgrades from MySQL versions older than ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...