Reset MYSQL root password on Windows server

1) Go to C:ProgramDataMySQLMySQL Server 5.6, note that ProgramData is a hidden folder or your path might be different open services and double click on the MYSQL service to view installed location.

 

2) Look for the file my.ini, open it and add one line “skip-grant-tables” below [mysqld], save my.ini

[mysqld]

skip-grant-tables

 

3) Start service mysqld

 

4) You can access the database, and use the query below to update the password

update mysql.user set password=PASSWORD(‘new password’) where user=’root’;

 

5) Shutdown the service again, remove the line skip-grant-tables save it, and start the service again. Try to use the password you set to login.