SET PASSWORD

Sets a user’s password.

Syntax

SET PASSWORD FOR 'username'@'host' = PASSWORD('password')

Remarks

  • 'password' is a clear-text password. The PASSWORD function creates a hash of the clear-text password and assigns it to the user.

  • This command allows users to change their own password. You can change another user’s password with this command if you have SUPERor ALTER USER privileges.

  • This command only changes the user’s password for that specific node, not for every node in the cluster.

  • Refer to the Permission Matrix for the required permission.

Note

Once the password is changed, it cannot be viewed.

Examples

SET PASSWORD FOR 'joe'@'%' = PASSWORD('securePass');

To unset a password:

SET PASSWORD FOR 'joe'@'%' = PASSWORD('');

Last modified: April 4, 2023

Was this article helpful?