On this page
Sets a user’s password.
SET PASSWORD FOR 'username'@'host' = PASSWORD('password')
'password'is a clear-text password.
PASSWORDfunction 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
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.
Once the password is changed, it cannot be viewed.
SET PASSWORD FOR 'joe'@'%' = PASSWORD('securePass');
To unset a password:
SET PASSWORD FOR 'joe'@'%' = PASSWORD('');
Last modified: April 4, 2023