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

owen
asked Apr 6, 2017
1 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..!!!!

View More
jagannatharumugam
answered Apr 6, 2017
Your Answer
||||
x
 
100:0