OpenSUSE Linux Rants

OpenSUSE Linux Tips, tricks, how-tos, opinions, and news

My Resume  -  My LinkedIn Profile

June 11, 2009

Reset MySQL root Password in Linux

by @ 9:36 pm. Filed under Linux tips

Stolen From Here

Reset Forgotten MySQL Root Password

Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article. Original article posted on reset mysql root password.

First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.

mysqld_safe –skip-grant-tables

You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.

mysql –user=root mysql

update user set Password=PASSWORD(‘new-password’) where user=’root’;
flush privileges;
exit;

Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.

3 Responses to “Reset MySQL root Password in Linux”

  1. Viktor Says:

    Thanks for this! Always handy to know.

  2. wagg.it Says:

    OpenSUSE Linux Rants…

    OpenSUSE Linux Rants provides tips, tricks, articles, news, opinions, tutorials, and howtos regarding opensuse and suse linux….

  3. socialwebcms.com Says:

    OpenSUSE Linux Rants…

    OpenSUSE Linux Rants provides tips, tricks, articles, news, opinions, tutorials, and howtos regarding opensuse and suse linux….

OpenSUSE Linux Rants
Official OpenSUSE Linux Site

internal links:

categories:

SUSE Resources

search blog:

archives:

January 2022
S M T W T F S
« Feb    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

60 queries. 0.197 seconds