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/password-hashing.html
Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication plugins. This includes removal of the mysql_old_password authentication plugin ...MySQL lists user accounts in the user table of the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
MySQL enables database administrators to expire account passwords manually, and to establish a policy for automatic password expiration. For accounts that use plugins that perform authentication against an external credentials system, password ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...For similar information about client-side logging, see Section 4.5.1.3, “mysql Client ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and monitored. For example, --validate-password=FORCE_PLUS_PERMANENT tells the server to load the ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This plugin exposes a set of system variables that enable you to configure password policy. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. The methods you ...Use the mysql_config_editor utility, which enables you to store authentication credentials in an encrypted login path file named ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 6.2.11, ...Which ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. If such statements are logged by the MySQL server as written, passwords in them become visible to ...For security reasons, this option is not recommended for production ...
https://dev.mysql.com/doc/refman/5.7/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). To work around it, change your MySQL password to a value that is eight or fewer characters long, or put ...That is a problem with the system library, not with ...