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 ] [[email protected] /]# 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 [[email protected] /]# mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
The option is called --skip-grant-tables, not --skip-tables-grants. Take a look at http://www.howtoforge.com/reset-forgotten-mysql-root-password
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