Home windows Password Reset MySQL in Windows

Password Reset MySQL in Windows

Author

Date

Category

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.

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions