How to Recover MYSQL Password

var AdBrite_Title_Color = ‘0000FF’;
var AdBrite_Text_Color = ‘000000′;
var AdBrite_Background_Color = ‘FFFFFF’;
var AdBrite_Border_Color = ‘CCCCCC’;
var AdBrite_URL_Color = ‘008000′;

Your Ad Here

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