How to reset mysql root password (Windows)
Of course, it is not my post. But I wrote it here for a back up for myself. I got this from some website, it works !
Steps1)
- Stop running Mysql service first (Administrative tools > Services )
- Open command prompt (cmd) and reach the directory (using CD command) where Mysql bin is installed (eg: C:/Program Files/Mysql/bin)
- type mysqld.exe -u root –skip-grant-tables and press enter (don’t close this command prompt)
- Open new command prompt and reach the same Mysql bin directory
- type mysql and press enter (This time, it never prompts for any passwords and you can enter mysql console)
- type command use mysql to switch your database into mysql
- Execute the usual command to change password for rootUPDATE user SET Password = PASSWORD(‘your_new_password’) WHERE User = ‘root’;
- Close the command prompts and go to services , start mysql. Now you can login with your new root password
Thanks and have a nice day
Sajith
Thanks for this, I just had two issues with it.
At Step 4 it needs to be –skip….
and at Step 8 I needed to go to Task Manager and kill the mysqld.exe process first, in order to restart the service.