Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.
Sets a user’s password.
SET PASSWORD FOR 'username'@'host' = PASSWORD('password')
'password'is a clear-text password. The
PASSWORDfunction creates a hash of the clear-text password and assigns it to the user.
Once the password is changed, it cannot be viewed.
SET PASSWORD FOR 'joe'@'%' = PASSWORD('securePass');