SET PASSWORD
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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 SUPER
orALTER USER
privilege. -
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: March 7, 2025