The magical thing that happens after MySQL forgets the password

I probably didn't forget the code.

But I can't get in, okay? Unload the reload, found that there is no password to set the step.

How to find online:

Tip: In C:\Program files\mysql\mysql Server 5.6\bin shift+ right-click. Open command line here
--skip or something. Hint: Can ' t create test file Localhost.lower-test ...
The reason is that this folder read and Write permissions are limited (possibly because of win8).
Right-click this folder. It's okay to change the permissions on the security editor.
1. Turn off MySQL. EXE 2. --skip 3. No password login 4 Flush 5 Restart
Change the details of the password Wood walk:
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 and, if successful, the 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

However, restarting the MYSLQ service prompts an unexpected abort. But... I can still log in and use my password after I change it.

But the next time you turn on, enter and say my password is wrong .... Well, I would like to change the password is not very good, after changing the password and then

mysqladmin-u user-p Password Password
After this command, you will be prompted to enter your original password, and you can modify it after entering it correctly.
For example, to set the root user's password to 123456, the
Mysqladmin-u root-p Password 123456

The expression is not spiritual.

The next boot is also the wrong password, this bug

Uninstall and then delete the light files after re-installation, OK.

Oracle is always used. Use the next MySQL so magic is really not confidence in the use of the future

This is copied from the Csdn. When Csdn put Sina's things, he moved csdn to this place.

The magical thing that happens after MySQL forgets the password