MySQL Sometimes forget the password what to do? I give a case and a description!
The actual operation under Windows is as follows
1. Close the running MySQL.
2. Open the DOS window and go to the Mysql\bin directory.
3. Enter Mysqld--skip-grant-tables carriage return. If the message doesn't appear, it's right.
4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory.
5. Enter MySQL return, if successful, a MySQL prompt will appear >
6. Connection rights database >use MySQL; (> is the original cue, don't forget the last semicolon)
6. Change Password:> update user set Password=password ("520") where user= "root"; (Don't forget the last semicolon)
7. Refresh permissions (required steps) >flush privileges;
8. Exit > \q
9. Log out of the system, then enter, open MySQL, use the username root and just set the new password 123456 to login.
》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》
Phpadmin password changes cannot be logged in, locate the configuration file under the Phpadmin installation directory. Add a password!
Mysql forgot password + phpadmin change Password cannot login