To err is human. Humans forget things, MySQL root password is one of those things. However, its not very difficult to reset the root password if you have root access to the machine.

The tutorial does seem a bit long because of all the alternate ways to kill and start the mysqld, but trust me its simple.

Here’s in short what we will be going to do:

• Step 1: Stop mysql server process
• Step 2: Start mysqld with --skip-grant-tables option.
• Step 3: Run mysql without any parameters.
• Step 4: Change the root admin password (old password not required.)
• Step 5: Close mysql and restart mysql server.

And here are the detailed instructions to reset MySQL root password: Read the rest of this entry »