Thursday, February 14, 2008

reset MYSQL "root" password

How to reset MYSQL "root" password :

Stop mysqld and restart it with the --skip-grant-tables --user=root options
(Windows users omit the --user=root portion).

Connect to the mysqld server with this command:

shell> mysql -u root
Issue the following statements in the mysql client:

mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;

No comments: