PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
If a user name and a password are supplied with MYSQL_USER and MYSQL_PASSWORD, the user is created and granted superuser access to this database (corresponding to GRANT ALL). MYSQL_USER, MYSQL_PASSWORD: These variables are used in conjunction to ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
(For a discussion of concepts involved in proxying, see Section 6.2.14, “Proxy Users”.) An account that authenticates using mysql_no_login may be used as a proxied user for proxy accounts: -- create proxied account CREATE USER ...Use cases for ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
NO_AUTO_CREATE_USER Prevent the GRANT statement from automatically creating new user accounts if it would otherwise do so, unless authentication information is specified. It is preferable to create MySQL accounts with CREATE USER rather than GRANT.
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
To require use of encrypted connections by a MySQL account, use CREATE USER to create the account with a REQUIRE SSL clause, or use ALTER USER for an existing account to add a REQUIRE SSL clause. For additional details about which command options ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To use this REVOKE syntax, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. User accounts from which privileges are to be revoked must exist, but the privileges to be revoked need not be ...The ...When the read_only system variable is enabled, REVOKE requires the SUPER privilege in addition to any other required privileges described in the following ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
MySQL reserves one extra connection to be used by accounts that have the SUPER privilege, to ensure that administrators should always be able to connect and check the system (assuming that you are not giving this privilege to all your users). If you ... SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
The latter distinguishes the system user and regular user account categories (see Account Categories). Note The processlist table is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher. If you have the ...The MySQL process list indicates the operations currently being performed by the set of threads executing within 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. For example: RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1'; The host name part of the account name, if omitted, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
For more information about MySQL user accounts and passwords, see Section 6.2, “Access Control and Account Management”. This password is associated with a MySQL user account only, and is not related in any way to the password used with encrypted ...Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The option does not affect authentication (4.1 and later clients can still use accounts that have long password hashes), but it does prevent creation of a long password hash in the user table as the result of a password-changing operation. MySQL ...