PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
old-password new_password This is like the password command but stores the password using the old (pre-4.1) password-hashing format. (See Section 6.1.2.4, “Password Hashing in MySQL”.) This command was removed in MySQL 5.7.5. This changes the ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if you have not already done so. A password may already be assigned to the initial account under these circumstances: On ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
The client-side mysql_clear_password plugin is built into the libmysqlclient client library. For connections by accounts that use this plugin, client programs use the client-side mysql_clear_password plugin, which sends the password to the server as ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. No password is sent because neither ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
Some encryption functions return strings of ASCII characters: MD5(), PASSWORD(), SHA(), SHA1(), SHA2(). Caution Passwords or other sensitive values supplied as arguments to encryption functions are sent as cleartext to the MySQL server unless an SSL ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--connect-expired-password Command-Line Format --connect-expired-password Indicate to the server that the client can handle sandbox mode if the account used to connect has an expired password. This can be useful for noninteractive invocations of ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
After a fresh installation, if you try to log on to the server as root without using a password, you might get the following error message. $> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means ... 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/mysql-config-editor.html
Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, user, password, port and socket. Here is an unobfuscated example: [client] user = mydefaultname password = mydefaultpass host = ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
--get-server-public-key Command-Line Format --get-server-public-key Introduced 5.7.23 Type Boolean Request from the server the public key required for RSA key pair-based password exchange. This option applies to clients that authenticate with the ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...For information about the caching plugin, see Section 6.4.1.4, “Caching SHA-2 Pluggable ...