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

This article mainly introduces the common methods to solve mysql prompt error 10061, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance to everyone's reference, the following is to understand with the author the common methods to solve mysql prompt error 10061.

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

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

-

Neither of the above methods can solve my problem.

However, in fact, the above two methods have already reached the point. That is, my MySQL hasn't been started yet. So how do you turn it on?

Enter the BIN directory under DOS

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

Then, type net start mysql directly

And then enter will be fine.

The screenshot is as follows:

Or directly.

If you encounter such problems in your work, you can try the above methods.

After reading the above common methods to solve mysql prompt error 10061, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

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.