How to solve the problem of flash back mysql
The first step: find the configuration file to my ini, then open it with notepad

Step 2: after opening, keyword search mysqld, find, add under the mysqld skip - grant - tables, keep out,
PS: if the tip is not to save, can the file to the desktop, shear are saved and then copied to the mySQL directory,

Step 3: save and restart mysql services, right-click on the computer - & gt; Management - & gt; Service - & gt; Mysql, and then restart,

Step 4: then run the CMD, input mysql -u root -p can need not password, password: when can directly enter into the

Step 5: modify the login password

1. Enter the mysql database: mysql> use mysql; The Database changed
2. Give the root user set a new password: mysql> Update the user set the password=password (" 123456 ") where the user="root";
3. Refresh the database mysql> Flush privileges;
4. Out of mysql: mysql> The quit

Step 6: change is good, then repaired my. Ini this file, we just add "skip - grant - tables" this line to delete, save the exit and restart the mysql service,

CodePudding user response:

Find many sites are useless, which should be solved with the solution you solved,

CodePudding user response:

Really works! Thank you thank you!

CodePudding user response:

Big bad ah

CodePudding user response:

Bypass security change passwords, but most just to use this method, the thumb up