fortypoundhead.com

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: 646


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

    output
    mysql>

  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

FortyPoundHead 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:54.198.233.27

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



Recent Forum Posts

Fold Code Manager into main KB?
VB6Boy posted on July 22, 2017 at about 14:42 in Site News

Fold Code Manager into main KB?
dwirch posted on July 22, 2017 at about 14:41 in Site News

Fold Code Manager into main KB?
dwirch posted on July 21, 2017 at about 22:46 in Site News

Fold Code Manager into main KB?
dwirch posted on July 20, 2017 at about 7:55 in Site News

Job Spammer: Sam Mallon
dwirch posted on July 18, 2017 at about 18:36 in Spammers

When setting up a certificate authority ...
dwirch posted on July 13, 2017 at about 9:07 in General