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/pam-pluggable-authentication.html
The PAM plugin uses the information passed to it by MySQL Server (such as user name, host name, password, and authentication string). Configure MySQL for PAM LDAP authentication as follows: Verify that Unix authentication permits logins to the ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
For example, the following statement is logged as shown because a password hash value is expected: CREATE USER 'user1'@'localhost' IDENTIFIED BY PASSWORD 'not-so-secret'; To guard log files against unwarranted exposure, locate them in a directory ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Clients (which are effectively users) connecting to the server then get an error indicating that the password must be changed: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. To avoid ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. Database administrators should use the following guidelines to keep passwords secure. The validate_password ...
https://dev.mysql.com/doc/refman/5.7/en/password-security.html
The following sections provide guidelines that enable end users and administrators to keep these passwords secure and avoid exposing them. There is also a discussion of how MySQL uses password hashing internally and of a plugin that you can use to ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-installation.html
For example, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=validate_password.so After modifying my.cnf, restart the server to cause the new settings to take effect. Note ... This section describes how to install the validate_password password-validation ...To be usable by the server, the plugin library file must be located ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege characteristics such as its password, whether it uses secure connections, and limits on access to server resources, then uses GRANT to define ...It is assumed that you establish passwords with CREATE USER at account-creation time to avoid creating insecure ...[REQUIRE {NONE | ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
To upgrade these accounts to use mysql_native_password explicitly, execute these statements: UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE plugin = '' AND (Password = '' OR LENGTH(Password) = 41); FLUSH PRIVILEGES; Before MySQL 5.7, ...For accounts corresponding to lines for which the password is empty, consider asking the account owners to choose a password (or require it by using ALTER USER to expire empty account ...If the plugin column is empty, the server authenticates the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
To dump grant table contents as logical definitions in the form of CREATE USER and GRANT statements, use the --users option and suppress all database dumping: mysqlpump --exclude-databases=% --users In the preceding command, % is a wildcard that ...