MySQL logon Failure error (10061) Solution

First, check that the MySQL service is not started. If it is not started, start the service.

Solution:

 

Step 1

Delete my. ini under c: \ windowns

Step 2

Open c: \ mysql \ bin \ winmysqladmin.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,Check whether the process is running normally. If not, go to the control panel and start it in the service to see 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.

Another way is to patch the server windows.

Microsoft released the TCP/IP update Patch (kb967723) on September 23, September 9. If the server enables automatic updates or the software is automatically updated to download and update the patch, this problem may occur.


Some may ask why the patch on the 9th has not been detected yet?


As we all know, the server does not restart every day. Some servers may restart once a month or a year or a half. Some may restart the server after January 1, September 9, so the patch takes effect (I personally think so ).

Patch uninstall method:Log on to the server and go to control panel --- add and deleteProgram
-- (Check "show updates" at the top ")


You can see the updated kb967723 patch in it, and uninstall it just like you want to uninstall common software. The uninstallation will prompt you. If the uninstallation may cause program running errors, it doesn't matter. Select "yes ", continue Uninstall.


After the uninstall is complete, the program server is running normally!


As to what vulnerabilities the patch patches fix and whether there will be server security risks after uninstalling the patch, this is the only way to solve this problem if MySQL runs normally.