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/grant.html
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ... Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE ...The discussion here describes the underlying structure of the grant tables and how the server uses their contents when interacting with ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. SHOW GRANTS requires the SELECT privilege for the ...Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER ...For additional ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The account for the proxied user must exist and be granted the privileges to be assumed by the proxy user. Granting and Revoking the PROXY Privilege The PROXY privilege is needed to enable an external user to connect as and have the privileges of ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. As of MySQL 5.7.19, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
In particular, you should keep in mind that NDB API and ClusterJ applications can read and write user names, host names, password hashes, and any other contents of the distributed grant tables without any restrictions. NDB Cluster supports ...This ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Of these, some can request that the MySQL server itself map proxy users according to granted proxy privileges: mysql_native_password, sha256_password. The default_authentication_plugin value affects these aspects of server operation: It determines ...Setting a session system variable value normally requires no special privileges and can be done by any user, although there are ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ... To use ALTER 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, ALTER USER ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
Windows pluggable authentication provides these capabilities: External authentication: Windows authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables who have logged in to Windows. If that user is ...Users who have logged in to Windows can connect from MySQL client programs to the server based on the information in their environment without specifying an additional ...