Recover MySQL root Password?

# service mysqld stop

 

# mysqld_safe --skip-grant-table &

               Press “ctrl + c”

 

# mysql -u root

mysql> show databases;

mysql> use mysql;

mysql> update user set password=PASSWORD(“<New Password>”) where user=’root’;

mysql> flush privileges;

mysql> quit

 

# service mysqld stop

 

# service mysqld start

 






Comments