How to reset the password in MySQL on Windows?
Answer 1, Authority 100%
mysqlinstanceconfig.exe in the MySQL folder there can be reconfigured
Answer 2
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.