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...

MySql Databse Password setup

In Red-hat enterprise Linux / CentOS Linux There is no Default Password set for MySQL Database server.


For Setting up password first time. 
If you have never set a root password 




$ mysqladmin -u root password NEWPASSWORD


if you want to change a root password


$ mysqladmin -u root -p'oldpassword' password NEWPASSWORD