Racker Hacker

If you’ve forgotten the root password for a MySQL server, but you know the system root, you can reset the MySQL root password pretty easily. Just remember to work quickly since the server is wide open until you finish working.

First, add skip-grant-tables to the [mysqld] section of /etc/my.cnf and restart the MySQL server.

Next, run mysql from the command line and use the following SQL statement:

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

Remove the skip-grant-tables from /etc/my.cnf and leave the server running. There’s no need to restart it.

This entry was posted on Sunday, March 25th, 2007 at 9:27 pm and is filed under Database, Security.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.