MySQL in a Nutshell

Name

SET PASSWORD

Synopsis

SET PASSWORD [FOR 'user'@'host'] = PASSWORD('password')

Use this statement to change the password for a user. If the FOR clause is not given, the current user is assumed. The PASSWORD( ) function will encrypt the password given. This statement does not require the use of the FLUSH PRIVILEGES statement. It will automatically update the privileges cache for the new password.

SET PASSWORD FOR 'kenneth'@'localhost' = PASSWORD('password');