Solve the problem that mysql enters the password to crash, mysql enters the password to crash

Solve the problem that mysql enters the password to crash, mysql enters the password to crash

Before starting this article, make sure that your mysql password is correct. Let's take a look at it later.

1. First, go to cmd and switch to the MySQL installation directory. Then, go to the bin directory and entermysqld-nt --skip-grant-tablesCommand.

Do not close this cmd window. open another window to log on to MySQL or click it directly.MySQL Command Line Client Enter the correct password!

2. On your WINDOWS Server, first press [start], then [run], Enter cmd, and then press Enter. In this DOS form, cd is written to the MySQL Server 5.1in directory, then run the mysql command:mysql -u root -p(Press Enter), Prompt: Enter password: Enter the password.

After you enter the password, the following error may occur:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

The error message above. This is because your mysql service has not been restarted. Enter msconfig in [run]

The "status" in is started by me. Before it is started, it is displayed that it has stopped. Let's take a look at how to start it.

If you do not have administrator permissions, the following error occurs when you enter net start mysql in the command prompt:

The solution is as follows:

Run in dosnet  start mysql Mysql cannot be started! Prompt system error 5; Access Denied! Switch to administrator mode. Therefore, we need to run the cmd program as an administrator to start mysql.

So how can I run the cmd program as an administrator?

1. Enter cmd in the search box of the Start menu, right-click it, and select Run as administrator!

If mysql is to be started every day, isn't it very troublesome? Therefore:

2. Right-click cmd and select "attach to [start] menu (U)". This is where you can find cmd on the Start Menu,

3. Right-click "select Properties", select "shortcut", select "advanced", run as administrator, and click "OK!

In the future, you only need to open the Start menu and click the shortcut above to run cmd as an administrator!

Enternet start mysqlThere will be no errors!

Summary

The above is all about this article. I hope this article will help you in your study or work. If you have any questions, please leave a message.