Mysql使用Navicat 连接报错 2003 - Can't connect to MySQL server on localhost' (10038)

2003 - Can’t connect to MySQL server on localhost’ (10038)错误

环境:win10/Mysql5.5

Navicat 连接数据库报错: 2003 - Can’t connect to MySQL server on localhost’ (10038)

无法连接到本地主机上的MySQL服务器

本来以为Mysql的服务没开,到服务里查看发现Mysql的服务都没有,有点尴尬/手动狗头

解决办法:

1.用管理员命令启动命令符(cmd)
Mysql使用Navicat 连接报错 2003 - Can't connect to MySQL server on localhost' (10038)

2.进入mysql的安装目录的bin目录下执行mysqld.exe -install(下图为是默认安装位置)
Mysql使用Navicat 连接报错 2003 - Can't connect to MySQL server on localhost' (10038)
成功的话会返回Service successfully installed.

3.启动Mysql服务执行:net start mysql**
Mysql使用Navicat 连接报错 2003 - Can't connect to MySQL server on localhost' (10038)