I just managed to mess up the MySQL root account. Not a smart idea. After some MySQL manual reading and some serious Google-Fu, I figured out how to fix it.

1. Stop the mysql server
2. Add the following to the my.cnf file
   [mysqld]
   skip-grant-tables
3. Start the mysql server
4. Start a mysql client and run the following query
   REPLACE INTO mysql.USER VALUES ('localhost','root',PASSWORD('blah'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
5. Quit the mysql client
6. Stop the mysql server
7. Remove what we added to my.cnf in step 2
8. Restart the mysql server

Tadaa.

I just managed to mess up the MySQL root account. Not a smart idea. After some MySQL manual reading and some serious Google-Fu, I figured out how to fix it. Stop the mysql server Add the following to the my.cnf file skip-grant-tables Start the mysql server Start a mysql client and run the following query REPLACE ...