打开Navicat,点击主机名/IP为localhost的连接,然后报错

2003-Can't connect to MySQL server on 'localhost'(10061)

 

1.开始→运行→services.msc(服务),未找到MySQL

 

2.重新安装MySQLInstanceConfig.exe未成功

 

Navicat 2003-Can't connect to MySQL server on 'localhost'(10061)_Navicat

 

3.找到my.ini文件

 

Navicat 2003-Can't connect to MySQL server on 'localhost'(10061)_MySQL_02

 

开始→运行→cmd,先进入所要安装的盘符,再进入my.ini文件所在的目录,把上图红框内my.ini的路径修改正确后运行

Navicat 2003-Can't connect to MySQL server on 'localhost'(10061)_MySQL_03

 

重启MySQL服务

 

Navicat 2003-Can't connect to MySQL server on 'localhost'(10061)_my.ini_04

 

然后就可以正常连接了