Recover MySQL root password

Posted On 2011-04-02 by FortyPoundHead
Keywords: recover lost forgot MySQL root password
Tags: Software Hack/Tweak Tip Tutorial 
Views: 678

It happens from time to time. For me, it happens after being on a long vacation. I forget my password, and the root password. Shame on me. Recovering is simpler than you think!

  1. Open console and stop mysql service
    #/etc/init.d/mysqld stop

  2. Then i run this service without password
    #mysqld_safe --skip-grant-tables
    You can also run it as a background if you would not use another console (shell)
    #mysqld_safe --skip-grant-tables &

  3. Then i open another console and connect to mysql
    #mysql -u root


  4. Next, i setup new password for root user
    mysql> use mysql;
    mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
    mysql> flush privileges;
    mysql> quit

  5. Last step is stop mysql service
    #/etc/init.d/mysqld stop

  6. Finish, and start mysqld and test new password
    #/etc/init.d/mysqld start
    #mysql -u root -p

About the Author

has posted a total of 1974 articles.

Comments On This Post

No comments on this post yet!

Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.

Your IP address is:

Before you can post, you need to prove you are human. If you log in, this test goes away.

Code Links