A solution to the Can ' t connect to MySQL server on ' localhost ' (10061)

Problem Description:

Using Navicat for MySQL cannot remotely connect to the local database, prompting can ' t connect to MySQL server on ' localhost ' (10038).

The MySQL service in the local service did not start and could not find the service.

Use cmd command line to open MySQL prompt Can ' t connect to MySQL server on ' localhost ' (10061)

After Baidu on the internet followed that a lot of programs also did not successfully solve the problem. Read a few more blogs, the next incredibly successful.

Specific steps

Open the cmd command line, enter the bin directory where MySQL is installed, enter Msqld.exe, and then press ENTER, without waiting, close cmd.

Open the cmd command line again, go to the MySQL bin directory again, enter Mysql.exe, and press ENTER. Wait for a few replies to start the MySQL service successfully

You can also successfully connect to the local database using Navicat for MySQL.

Sections such as

This method feels like it needs to be re-operated after each boot. This problem should be caused by disabling certain startup items. This problem occurs when I close all the startup items, because the computer prompts for an error and then restarts each time the software is opened. The later period still needs to be improved.

Because the study is not good enough, not familiar with this piece, the specific reasons I do not know, so successful, I hope the big guy can give an explanation, thank you. I also hope that this blog will provide some help to those who have encountered this kind of situation.

A solution to the Can ' t connect to MySQL server on ' localhost ' (10061)