1、MySQL 使用 Navicat 出现错误“2003 - Can't connect
to MySQL server on 'localhost' (10061)”,如图:
http://s14/middle/51eca055gc4ad2194c15d&690- Can't connect to MySQL server on 'localhost' (10061)" TITLE="2003 - Can't connect to MySQL server on 'localhost' (10061)" />
2、引起错误原因:MySQL服务没有开启
3、解决方法:开启MySQL服务,Win7中步骤如下:计算机,右键->管理->服务与应用服务->服务->MySQL服务,右键,启动->重新启动
Navicat,问题解决。(如图)
http://s16/middle/51eca055g7a1153bb701f&690- Can't connect to MySQL server on 'localhost' (10061)" TITLE="2003 - Can't connect to MySQL server on 'localhost' (10061)" />
http://s15/middle/51eca055gc4ad462df51e&690- Can't connect to MySQL server on 'localhost' (10061)" TITLE="2003 - Can't connect to MySQL server on 'localhost' (10061)" />
4、插曲
启动MySQL服务时出现错误:“Windows
无法启动MySQL服务(位于 本地计算机上)”“错误1067:进程意外终止”
http://s15/middle/51eca055gc4ad65e67c0e&690- Can't connect to MySQL server on 'localhost' (10061)" TITLE="2003 - Can't connect to MySQL server on 'localhost' (10061)" />
解决方法:(1)查看MySQL的my.ini文件。发现曾几何时把“default-character-set”和“character-set-server=utf-8”的编码latin1改为了utf-8。
(2)将编码改回latin1,保存my.ini文件。(3)重新启动
MySQL服务,重新启动 Navicat,问题解决。
加载中,请稍候......