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 PASSWORD
function creates a hash of the clear-text password and assigns it to the user.SUPER
privileges.Once the password is changed, it cannot be viewed.
SET PASSWORD FOR 'joe'@'%' = PASSWORD('securePass');