Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The solution to the problem of ERROR 2003 (HY000) when mysql starts

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

I. description of the problem

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

Second, problem analysis

You can see from the error that the MySQL service is not started, so you just need to start the MySQL service.

III. Problem solving

You can start the MySQL service directly with net start MySQL, but there is still an error after entering the command:

You can see the error message: "invalid service name", indicating that there is no MySQL service, but confirm that MySQL has been installed, so open computer management, find the service tag, and find the MySQL service, as shown in the figure:

It is found that the service name of the MySQL service on my computer is "MySQL57". In fact, you can directly click to start the service at this time to solve the problem, and you can enter the properties and change the startup type to automatic, but here you are going to continue to start with the CMD command. Enter net start MySQL57 at this time, and the result is as follows:

Another error occurred with the error message "system error 5. Access denied." After searching for information, it is found that the reason for this problem is that CMD is not running as an administrator, so restart CMD as an administrator, and type net start MySQL57 again. The result is as shown in the figure:

The service started successfully and the problem was resolved.

IV. Other questions

Why is my MySQL service called MySQL57? This is because I installed MySQL5.7, and during the custom installation, the default service name is MySQL57.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report