Recover MYSQL Password

Q: My root password lost?; can’t manage existing database can anyone help me?

A: Solution is simple just follow the steps below:
Recover MYSQL Password

#/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