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)
|