MySQL: How to reset ROOT password in Windows System?

In this post, I am sharing full steps on how to reset the forgotten MySQL ROOT password in Windows Operating System.

When you are installing MySQL, it asks for setting up a ROOT Password which the default admin setup of your MySQL Server.
I noticed that most of the people are forgetting the main ROOT password of MySQL and then You can’t connect to server/database.

I found multiple solutions, but here I am sharing two solutions.

One solution is given by MySQL Developer, for that please visit this link:

For alternative, please follow below steps:

Step 1:
Go to services.msc and stop the MySQL Service

Step 2:
Open Windows Command Prompt as an Administrator

Step 3:
Go to ../MySQL Server 5.7/bin/

Step 4: Execute this command

1	mysqld.exe -u root --skip-grant-tables

Step 5: Start the MySQL Service

Step 6:
Open a new Windows Command Prompt as an Administrator and go to MySQL/bin

Step 7:
Type MySQL and press enter. Now, you are in MySQL Console.

Step 8: Reset the password

1	UPDATE user SET Password = PASSWORD('New_Password') WHERE User = 'root';