Howto: Reset MYSQL root password February 11, 2009Posted by hasnain110 in Linux.
- Stop mysqld and restart it with the
--skip-grant-tables --user=rootoptions (Windows users omit the
- Connect to the mysqld server with this command:
mysql -u root
- Issue the following statements in the mysql client:
UPDATE mysql.user SET Password=PASSWORD('
- You should be able to connect using the new password.