How to reset the password in MySQL on Windows?
Answer 1, Authority 100%
mysqlinstanceconfig.exe in the MySQL folder there can be reconfigured
It is necessary to find the folder with where MySQL was installed, to find the My.ini file in it and in the
section [Mysqld] Print Directive
Skip-Grant-Tables , which will need to start Without a custom privilege table
[mysqld] ... SKIP-GRANT-TABLES
Next, you can refer to MySQL from any user without specifying the password
mysql -u root
After that, you can set a new password to the Root user
set password for 'root' @ 'localhost' = password ('new password');
After installing the password, you should delete the
SKIP-GRANT-TABLES directive from my.ini and restart the MySQL server.