Thursday, March 4, 2010

How to change MySQL user password

mysql -u root -p

mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='paul';