How to solve mysql error 10061

This article shares with you the solution to the problem "Can't connect to MySQL server on 'localhost' (10061)" for your reference. The specific content is as follows

Online search method 1:

Today I copied the MySQL database to another machine, but it failed to connect. It reported the error "Can't connect to MySQL server on 'localhost' (10061)". I searched online and found a very good article. Both methods can solve this problem.
1. Delete my.ini (under C:\windows\), re-run winmysqladmin, and after being asked to enter the username and password, the problem is solved!
2. Check if localhost in the hosts file points to 127.0.0.1

If the mysql service is not started, run net start mysql.
Some relevant commands:
mysqld-nt --install #Start MySQL
mysql #Run MySQL
mysql -h ipAddress -u username -p

Online search method 2:

Solution to mysql error 10061

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

This means your MySQL has not been started. Solution:

first step

Delete my.ini under c:\windowns

Step 2

Enter the BIN directory under DOS

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

Step 3

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

Then enter mysqld -nt -install to install the service

Step 4

Type net start mysql

mysql started successfully

--------------------------------------------------------------------------------------------------------

The above two methods did not solve my problem.

However, the above two methods have actually touched upon the point. That is, my MySQL has not been started. So how do you start it?

Enter the BIN directory under DOS

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

Then, just enter net start mysql

Then just press enter.

The screenshots are as follows:

Or directly

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.