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/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. For example: ALTER USER user IDENTIFIED BY 'auth_string'; Important Under ...= 'auth_string' syntax is not deprecated, but ALTER USER is the preferred statement for account alterations, including assigning ...For information ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
The client connects to the MySQL server, providing the MySQL client user name and the LDAP password: For simple LDAP authentication, the client-side and server-side plugins communicate the password as cleartext. The LDAP server looks for an entry ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The account for the external proxy user must be set up to be authenticated by the plugin. For example, root can do this: CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin_password'; GRANT PROXY ON ''@'' TO 'admin'@'localhost' WITH GRANT OPTION; ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Clients that connect to the server using the account 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 having such ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
After the client connects, it can (if it has sufficient privileges) set or change the password hash for accounts listed in the user table. The client can do this by using the PASSWORD() function to generate a password hash, or by using a ...MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
When validate_password_check_user_name is enabled, it has these effects: Checking occurs in all contexts for which validate_password is invoked, which includes use of statements such as ALTER USER or SET PASSWORD to change the current user's ...This ...For example, --validate-password=FORCE_PLUS_PERMANENT tells the server to load the plugin at startup and prevents it from being removed while the server is ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). For ...To assign a password when you create a new account, use CREATE USER and include an IDENTIFIED BY clause: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; CREATE USER also supports syntax for specifying the account authentication ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and SET PASSWORD; statements that use PASSWORD(), the validate_password capabilities described here apply only to accounts that use an ...This ...
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/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired ...If the server restricts the client to sandbox mode, these operations are permitted within the client session: The client can reset the account password with ALTER USER or SET ...