HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   Mysql password reset (http://www.howtoforge.com/forums/showthread.php?t=51399)

newbie14 11th February 2011 22:20

Mysql password reset
 
Dear All,
I have lost my root password so I am trying to reset and following steps I have run but failed. Any help please? Thank you.

service mysqld stop
Stopping MySQL: [ OK ]
[root@localhost /]# mysqld_safe --skip-tables-grants
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/localhost.localdomain.pid
110212 05:12:19 mysqld ended

[root@localhost /]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

falko 12th February 2011 11:36

The option is called --skip-grant-tables, not --skip-tables-grants. Take a look at http://www.howtoforge.com/reset-forg...-root-password

newbie14 12th February 2011 18:08

Dear Falko,
What I did was first I stop by this command service mysqld stop. Then I ran this mysqld_safe --skip-grant-tables. The problem it gave me the output below and just thats all kept there. Can I type in the empty space below where the last line?
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql

falko 13th February 2011 19:55

Yes, that should work.


All times are GMT +2. The time now is 20:54.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.