[Java] MySQL One flash exit solution

Symptoms: Enter the password a flash, a hint is not, the password first guarantee is correct.

So I thought of directly skip permission verification, using the following methods:
First, enter the cmd into the MySQL installation directory, and then cut into the bin directory, enter the mysqld-nt--skip-grant-tables command.

This cmd window does not close first, open another window to log in to MySQL or directly open the MySQL Command line Client input the correct password, OK!

Second, on your Windows, first press [start], then [run], enter CMD and return
And then in this DOS form, CD to \mysql Server 5.1\bin directory (carriage return) Note that the red words do not hit the Chinese characters, is to let you press ENTER, if you do not know where the return key, please check Google yourself.

And then Mysql-u root-p (carriage return) here the Scarlet Letter ibid.

Enter Password: Enter the password.
third, some friends after the above settings, login but also prompted "Mysql:unknown variable ' CHARACTER-SET-SERVER=GBK '", the solution is very simple (show me is the windows2003 environment), Modify the MySQL installation directory under the My.ini file, the inside of the DEFAULT-CHARACTER-SET=GBK comment or delete, in the service restart the MySQL service can be.

Another problem mysqld-nt--skip-grant-tables prompt is not internal or external command , direct start MySQL prompt error 2003 can ' t connect to MySQL server on ' localhost ' (10061)

Rescue method: Find My-small.ini copy Save as My.ini in [mysqld] Add a sentence bind-address = 0.0.0.0

Then start MySQL to connect. (Pro-test, available)

[Java] MySQL One flash exit solution