Follow three easy steps to recover mysql root password.
irst of all stop mysqld service
#service mysqld stop or /etc/init.d/mysqld stop
start with skip grant table option
#mysqld_safe --skip-grant-tables &
now login with root without any password
# mysql -u root
here you got it!
now for own safety change mysql root password
mysql> set password=PASSWORD('yourpasswd');
mysql> flush privileges;
now stop mysql service and start it again
#service mysqld stop or /etc/init.d/mysqld stop
start with skip grant table option
#mysqld_safe --skip-grant-tables &
now login with root without any password
# mysql -u root
here you got it!
now for own safety change mysql root password
mysql> set password=PASSWORD('yourpasswd');
mysql> flush privileges;
now stop mysql service and start it again
No comments:
Post a Comment