Recovering/Resetting MySQL Password In Easy Steps

Stop MySQL Server Deamon with its all processes :

# /etc/init.d/mysqld stop

Or

# killall mysql

Create MysQL Password reset Script by VI Text Editor :

# vi /root/mypassreset.sql

UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';FLUSH PRIVILEGES;


Save Your script(MySQL Query)

Run password reset script and set new password :

# mysqld_safe --init-file=/root/mypassreset.sql &



Now You have successfully setup a new password...