About MySQL database after entering the password, drops a direct Exit interface solution (Detailed method)

A while ago, due to write a program to use the database, it was downloaded in the book, but there are a lot of small problems (their desktop is not the problem, it may be my book too slag it), tangled up a good burst, think back, find problems, analysis problems, solve problems, is not our software management ideas, Only after experiencing the problem can we understand deeply. Don't say much nonsense, go straight to the question.

After downloading the MySQL, when you open the MySQL character interface (MySQL 5.5 Command line Client), enter the password (in the installation, manually set the wizard). There is a drop of a sound, and then a splash screen is over, my Computer a period of time, installed a MySQL 5.5, just started to use the time no problem, but suddenly, I opened the interface to enter the password, there is a splash screen situation, and visual management tools (I use SQLyog) also connected to the database, I searched in the evening, found that the problem is very common, through a variety of methods (the period is very torture, there is a desire to put the computer hit the impulse), finally fix, in this summary.

method One : If the input password splash screen situation, first to check whether the MySQL service is started, the way to see is: Right button "My Computer", "Management", "services and Applications", "services" to view the status of MySQL services, if not started , the service is started by right-clicking. Start the interface again, enter the password to see if it is possible, the general MySQL service is not open is the main reason. This reason is a lot of incentives, I last in the use of a free antivirus software optimization, MySQL service was unexpectedly closed, so in the optimization should pay special attention. Such as:

The second case :

If the first method does not work or "MySQL service" is originally open, at this time, it is likely that the configuration problem of MySQL, in fact, the problem appears in the "C:\ProgramFiles\MySQL\MySQL Server 5.0" My.ini file (under installation path), there is a problem with this configuration file. For this issue:

Method One : First enter cmd into the MySQL installation directory, 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 tap the MySQL CommandLine Client to enter the correct password. Can.

Method Two: Find out the Run (win+r), in this DOS form, CD to the bin directory of MySQL Server 5.5 (carriage return), and then Mysql-u root-p (carriage return), Enterpassword: Enter the password.

method Three : If login and Prompt "mysql:unknownvariable ' CHARACTER-SET-SERVER=GBK '", Workaround: Modify the MySQL installation directory under the My.ini file, the inside of the DEFAULT-CHARACTER-SET=GBK comment or delete, in the service to restart the MySQL service can be (in this case I have not met, stay for later encountered use it),

Double-click to open, find the appropriate location, make changes.

method Four : Go to the installation directory and delete the "My.ini" file,

Note: In method Two, when we enter the "mysqld-nt--skip-grant-tables" command under DOS, there may be an unrecognized condition (prompt is not internal or external command, direct start MySQL prompt error xxx can ' tconnect to MySQL Server on ' localhost ' (10061), the workaround is: Find My-small.ini (this file is in the installation directory) copy Save as My.ini in [mysqld] Add a sentence bind-address =0.0.0.0

No recognition occurs:

Workaround:

Then start MySQL to connect.

Enter Password:

The above method, is the online search method summary, coupled with my own hands-on practice, these methods can solve the above problems, if still not, long pain is not as short as the pain, uninstall the reinstall, re-install the attention of the items please refer to (MySQL uninstall notes/HTTP/ blog.csdn.net/u014028070/article/details/41895367).

About MySQL database after entering the password, drops a direct Exit interface solution (Detailed method)