In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
Data types and distributed storage = Overview: =
© 2024 shulou.com SLNews company. All rights reserved.