How to solve the problem of ERROR 2003 (HY000) when starting mysql

1. Problem Description

When starting MYSQL, a problem occurs: "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)", as shown in the figure:

2. Problem Analysis

From the error message, we can see that the MySQL service is not started, so we just need to start the MySQL service.

3. Problem Solving

You can start the MySQL service directly using net start MySQL , but an error still occurs after entering the command:

You can see the error message: "Invalid service name", which means that the MySQL service does not exist, but it is confirmed that MySQL has been installed, so open Computer Management and find the Service tab, where you can find the MySQL service, as shown in the figure:

I found that the service name of the MySQL service on my computer is "MySQL57". In fact, you can directly click to start this service to solve the problem, and you can enter the properties and change the startup type to automatic. However, I plan to continue to use the CMD command to start it. At this time, enter net start MySQL57 , and the result is as shown in the figure:

Another error occurred, and the error message was "System error 5. Access denied." After searching for information, I found that the reason for this problem was that CMD was not run as an administrator, so I restarted CMD as an administrator and entered net start MySQL57 again. The result is as shown in the figure:

The service was started successfully and the problem was solved.

4. Other questions

Why is my MySQL service named MySQL57? This is because I installed MySQL 5.7, and during the custom installation process the default service name was MySQL 57.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.