Solve the problem of MySQL input password flash back

MySQL, which was installed shortly before, has been running normally, with a VS2010 flagship version yesterday. As a result, MySQL can't be used today. No language

On the Internet to see the most as long as the MySQL service is not up for the sake of.

Here are a few solutions, in fact, there are a lot of the same on the Internet, I keep to prevent future problems to find.

First of all, make sure your MySQL password is right or you will think of his way.

One

First enter 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!

Two

On your Windows, first press [start], then [run], type cmd and then enter, in this DOS form, CD to the MySQL Server 5.1in directory, and then use the MySQL command: mysql-u root-p (carriage return), Tip: Ente R Password: Enter the password.

May appear after entering the password:ERROR 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061)

The above error prompt. This is because your MySQL service is not restarted, enter msconfig in [run]

In the "status" is I started, did not start before the display is stopped, the following is to say how to start it.

If you do not have administrator privileges at the command prompt, input net start MySQL will appear the following error:

Here's how to solve the problem:

Running net start MySQL under DOS cannot start mysql! Prompt for system error 5; Access Denied! Switch to administrator mode to start up. So we have to run the CMD program as an administrator to start MySQL.

So how to run the CMD program with the administrator status?

1. In the Start menu, enter CMD in the search box, then right-click and select Run as Administrator!

Wouldn't it be a hassle if you started the MySQL service every day? So:

2. Right-click cmd Select "Attach to Start menu (U)"; This is where you can find cmd on the Start menu,

3. Right-click on select Properties, select Shortcut, then select Advanced, Run as Administrator, then click OK!

Just open the Start menu and click on the shortcut above to run cmd as an administrator!

Then enter net start MySQL will not be wrong!

Solve the problem of MySQL input password flash back