ALTER USER
Description
Changes user information.
Syntax
ALTER USER
user_identity [auth_option]
user_identity:
'user_name'@'host'
auth_option: {
IDENTIFIED BY 'auth_string'
IDENTIFIED WITH auth_plugin
IDENTIFIED WITH auth_plugin BY 'auth_string'
IDENTIFIED WITH auth_plugin AS 'auth_string'
}
The command is used to change user information.
"auth_option" specifies authentication method. It currently supports "mysql_native_password" and "authentication_ldap_simple".
Examples
-
Change user's password in mysql.
ALTER USER 'jack' IDENTIFIED BY '123456';
or
ALTER USER 'jack' IDENTIFIED WITH mysql_native_password BY '123456';
-
To avoid transmitting password in plaintext, the following method can also be used to change password.
ALTER USER 'jack' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9';
or
ALTER USER 'jack' IDENTIFIED WITH mysql_native_password AS '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9';
The encrypted content can be obtained by "PASSWORD()", for example:
SELECT PASSWORD('123456');
-
Alter user authentication method as "ldap".
ALTER USER 'jack' IDENTIFIED WITH authentication_ldap_simple
-
Alter user authentication method as "ldap", and specify user's DN (Distinguished Name) in ldap.
ALTER USER 'jack' IDENTIFIED WITH authentication_ldap_simple AS 'uid=jack,ou=company,dc=example,dc=com'