SET PASSWORD

SET PASSWORD changes the login password for users. The ALTER USER command can also be used to change a password.

:::tip

• All users can reset their own password.
• Only users with the user_admin role can change the password of other users.
• Only the root user itself can change its password. For more information, see the priviege overview.

:::

Syntax

SET PASSWORD [FOR user_identity] =
[PASSWORD('plain password')]|['hashed password']

The user_identity must match exactly the user_identity specified when creating a user by using CREATE USER. Otherwise, the user will be reported as non-existent. If user_identity is not specified, the password of the current user will be changed. The current user can be viewed through SHOW GRANTS.

PASSWORD() inputs a plaintext password. If you directly input a string without using PASSWORD(), the string must be encrypted.

Examples

1. Set the password for the current user.

   SQLCopy

   SET PASSWORD = PASSWORD('123456')
   SET PASSWORD = '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9'
   

2. Set the password for a specified user.

   SQLCopy

   SET PASSWORD FOR 'jack'@'192.%' = PASSWORD('123456')
   SET PASSWORD FOR 'jack'@['domain'] = '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9'