View Single Post
  #1  
Old 11th February 2011, 22:20
newbie14 newbie14 is offline
Member
 
Join Date: Jul 2010
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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)
Reply With Quote
Sponsored Links