Recover MYSQL Password
March 20, 2008
Q: My root password lost?; can’t manage existing database can anyone help me?
A: Solution is simple just follow the steps below:
A: Solution is simple just follow the steps below:
Recover MYSQL Password
#/etc/init.d/mysql stop
#/etc/init.d/mysql stop
Please wait until MySQL shuts down completely. Then run
#/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &
then you will be able to login as root with no password.
#mysql -uroot mysql
In MySQL command line prompt issue the following command:
mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”;
FLUSH PRIVILEGES;
mysql>exit
kill all the mysql processes
#/etc/init.d/mysql stop
Start MySQL again
#/etc/init.d/mysql start
At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:
mysql -uroot -pletmein mysql
Congratulations you have sucessfully changed your new password 
