During development, MySQLlocalhost (10061) is often used to solve this problem. I used to install the windTCPIP update Patch (KB967723) and encountered an error. Today it is different. The following is a solution, if you need it, analyze it.
During development, MySQL localhost (10061) is often used to solve this problem. I used to install the wind TCP/IP update Patch (KB967723) and encountered an error. Today it is different, the following is a solution. If you need it, analyze it.
Step 1
Delete my. ini under c: windowns
Step 2
Open c: binwinmysqladmin.exe and enter the user name and password.
Step 3: Input mysqld-nt-remove in dos to delete the service
Enter mysqld-nt-install
Step 4: enter that mysql is started successfully.
Other methods for reference:
1. Check whether the localhost In the hosts file points to 127.0.0.1.
2. If the mysql service is not started, you can run net start mysql.
3. Some related commands:
Mysqld-nt -- install # Start Mysql
Mysql # Run Mysql
Mysql-h ipAddress-u username-p
Or: directly go to the binpoint mysqld.exeor mysqld-nt.exe to check whether the process is running normally. If not, go to the control panel and start it in the service to check what is wrong. If not, delete mysql in the Add/delete operation and reinstall mysql. Generally, the problem can be solved. You can back up DATA before installation.
Error: Can't connect to MySQL server on 'localhost' (10061)
Errno.: 2003
Error No.: 2003
Problem Analysis:
Unable to connect to the MySQL server, possible situation:
1. the MySQL service is not started. It is generally caused by the failure of MySQL to start in case of exceptions, such as no available disk space or incorrect basedir path setting of MySQL in my. ini;
2. the MySQL server cannot be connected due to insufficient resources.
Solution:
1. If you are a VM user (purchased space), contact the Space Provider to check whether MySQL is started normally and confirm the MySQL configuration information (whether it is localhost );
2. If you are an independent host user (with host management permissions), perform the following steps:
1) check whether there is any available space in the disk space and try to keep enough disk space available.
2) check whether the parameter settings of basedir (MySQL installation address) and datadir (data directory storage address) in my. ini are correct, and then restart the MySQL service.