Categories

Wednesday 4 April 2012

how to recover mysql root password

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 

No comments:

Post a Comment

Ad