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/create-user.html
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system database. When the read_only system variable is enabled, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
By default, mysqlpump does not dump user account definitions, even if you dump the mysql system database that contains the grant tables. To dump grant table contents as logical definitions in the form of CREATE USER and GRANT statements, use the ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
If the base DN is ou=Admin,dc=example,dc=com: Searches find user entries only in the second set. If the base DN is ou=dc=example,dc=com: Searches find user entries in the first or second set. Authentication uses either one or two LDAP bind ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. For ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the ...On ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
These examples assume that the MySQL root account has the CREATE USER privilege and all privileges that it grants to other accounts. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
GRANT OPTION Enables you to grant to or revoke from other users those privileges that you yourself possess. GRANT OPTION enables users to give their privileges to other users. Two users that have different privileges and with the GRANT OPTION ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
However, use of Host values ending with % is insecure and is not recommended!) If mysql -u user_name works but mysql -u user_name some_db does not, you have not granted access to the given user for the database named some_db. The grant tables must ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
(You may find it helpful to refer to Section 6.2.3, “Grant Tables”, which lists the columns present in each grant table.) The user table grants global privileges. For example, if the user table grants you the DELETE privilege, you can delete ...