0

How to reset MySQL root password

I had set the root passwd for mysql but the passwd is not known. Is it possible to retrive that passwd ...??

MySQL Root Add a comment
owen
asked Apr 06 2017

Answer

0

Yes definitely its possible, just follow the below steps,

  1. Stop the Mysql service with pid.
  2. Then run mysqld_safe --skip-grant-tables & command.
  3. It will skip the specific table and start the Mysql service.
  4. Now login to mysql server and update the password for root user.

    -> use mysql;

    -> update user set password=PASSWORD("testing") where User='root';

    -> FLUSH PRIVILEGES;

Replace the "testing" with your password and start using Mysql with your new password..!!!!

Add a comment
jagannatharumugam
asked Apr 06 2017
edited Oct 05 2018
Post your Answer