HowTo: Mysql Update Password SQL Command

by on December 6, 2012· last updated at December 6, 2012

Fig.01: Mysql Updating / Changing password (click to enlarge)

The sql syntax is as follows and you must login as root (mysql server administrator) user account:

SET PASSWORD FOR 'user'@'host' = PASSWORD('password');

OR

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='user' AND Host='host';

You must flush the privileges

FLUSH PRIVILEGES;
Read answer to: "MySQL Change a User Password"

Comments on this FAQ are closed. If you'd like to continue the discussion on this topic, you can do so at our forum.