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 error message 10061 when mysql can't connect

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

Share

Shulou(Shulou.com)05/31 Report--

This article mainly introduces the mysql can not connect to the error prompt 10061 solution, the article is very detailed, has a certain reference value, interested friends must read it!

Mysql cannot connect to the solution for error 10061: first delete [my.ini], rerun winmysqladmin and ask for a user name and password, and then see if localhost points to [127.0.0.1] in the hosts file.

The operating environment of this tutorial: windows7 system, mysql8.0.22 version, DELL G3 computer.

Mysql cannot connect to the workaround where error 10061 occurs:

Online search method 1:

Today, I copied the mysql database to another computer. As a result, I couldn't connect and reported a "Can't connect to MySQL server on 'localhost' (10061)" error.

When I went to search on the Internet, I found that an article was very good, and both methods could solve this problem.

1. Delete my.ini (under C:\ windows\), run winmysqladmin again, and enter a user name and password, and the problem is solved!

2. See if localhost points to 127.0.0.1 in the hosts file.

If the mysql service is not started, you can run net start mysql.

Some related commands:

Mysqld-nt-- install # launch Mysql mysql # run Mysql mysql-h ipAddress-u username-p

More free learning recommendations: mysql tutorials (video)

Online search method 2:

10061 error solution in mysql

If "ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)" appears

It means that your MySQL has not been started yet. Solution:

The first step

Delete the my.ini under c:\ windowns

Step two

Enter the BIN directory under DOS

C:\ Program Files\ MySQL\ MySQL Server 5.4\ bin

Step three

Enter mysqld-nt-remove to delete the service under DOS

Then type mysqld-nt-install to install the service

The fourth step

Enter net start mysql

Mysql started successfully

The above is all the contents of the article "mysql can not connect to the solution to error prompt 10061". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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

Wechat

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

12
Report