Mysql Strange Connection Error

Today, a database connectivity issue has been encountered:
Unlike the previous MySQL connection problem on Linux, which is the permission setting, the origin of this problem is:

I want to import a CSV file to MySQL, but because the file is larger, there is 88M data, the use of Navicat client import will produce an unresponsive, so can only be imported with the MySQL command, and inadvertently found a problem, database connection error, in order to ensure that nothing wrong, I'll break the service first, and then get up again, no problem, okay!. Such as

But this time from the Navicat client to open the local connection, found that can not open, and out of this like a novice will appear error; so I find a solution to all kinds of Baidu

solution or that is to say the hosts address localhost does not map, I looked at the next no problem;

Otherwise it is said that the password is wrong, to reset, I tried the next or not even;

Even more decided to re-Ann MySQL and the client, I definitely do not try this old laborious way, so carefully to see my service, suddenly found that there are two MySQL services: MySQL and mysql55

I suddenly realized that it was not quite right, so I broke the MySQL service, opened Mysql55 service, suddenly, Navicat can be locally connected;

I guess the reason may be before the MySQL, and uninstall, but the service may not be complete, leaving a residue , I checked for a long while.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Mysql Strange Connection Error