Wonder how to reset Mysql Password ?

Forgetting? Isn’t that a Sign Of Old Age? 😉 . Okay , I’m here to help you! You can reset the mysql password as follows :-

First you need to stop the mysql service by running the following command :

service mysql stop

Now Run the following command and it will start the mysql in the background without any privileges .

/usr/bin/mysqld_safe –skip-grant-tables &

Now you will be able to login into mysql without any password. Once logged in, set your new mysql password.

#mysql
mysql> use mysql;
mysql> update user set password=PASSWORD(“new_password_here”) where User=’root’;
mysql> flush privileges;
mysql> quit;

service mysql restart

Hey , you should now be able to login . Cheers!