mysql_updatepass []

This is an old revision of the document!

Changing a users password

UPDATE mysql.user set Password=PASSWORD('newpassword') WHERE User='user' AND Host='x.x.x.x';

You are also able to use the following command, this will change the password for ALL users with the matching username, so you do not have to declare the host:

update mysql.user set password=PASSWORD('newpassword') where User='luke';