owen
asked Apr 06 2017
Answer
Yes definitely its possible, just follow the below steps,
- Stop the Mysql service with pid.
- Then run mysqld_safe --skip-grant-tables & command.
- It will skip the specific table and start the Mysql service.
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..!!!!
jagannatharumugam
asked Apr 06 2017
edited Oct 05 2018
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 ...??