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
Post a Comment