MySQL问题：2002 - Can‘t connect to server on ‘localhost‘(10061)【已解决】

﹏ヽ暗。殇╰゛Y 2024-04-01 14:47 53阅读 0赞

### 1.报错范围 ###

2002，2003，1045，1064  
![在这里插入图片描述][f14c48d21b624858a10f44670b5ef6f1.png]  
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)  
![75bd960462d14d4cab5ab7dfab96ccac.png][]

### 2.查看mysql是否启动 ###

**搜服务/找到服务**  
![在这里插入图片描述][67ea87a26f8b479299fd064a364be9f9.png]

**按字母顺序找到mysql，将其启动。**

![在这里插入图片描述][dab7469c6aed4471bb65568550e2dd9f.png]

### 3.查看端口号 ###

mysql的默认端口号是3306，查看方法：1、打开cmd命令行；2、执行`mysql -u root -p`命令，输入密码来连接mysql服务；3、执行`show global variables like 'port';`命令即可查看。

win+R运行cmd，输入`mysql -u root -p`  
在mysql>下输入 `show global variables like 'port';` ![在这里插入图片描述][7dbbd2527acb413fbad33341765ff3e5.png]

查看端口号。使navicate、my.ini中的端口号与其一致。

![在这里插入图片描述][0080df6ab3cb4897912e1a20deaad8b8.png]  
![在这里插入图片描述][3017dbb7dc454c22957d38c4aec2224d.png]

参考：  
出现问题：  
1.考虑到可能因为mysql下载太多的原因，卸载多余MySQL；删除多余mysql并重启电脑，mysql服务可执行文件的路径依旧是已删除的路径。按照[MySQL–修改mysql服务可执行文件的路径（Windows）][MySQL_mysql_Windows]修改路径成功。  
2.[MySQL修改密码时，报错ERROR 1064 (42000)【新版MySQL修改密码命令有所变更][MySQL_ERROR 1064 _42000_MySQL]  
最终通过3和4解决，连接成功。  
3.[navicat创建连接 2002-can‘t connect to server on localhost（10061）且mysql服务已启动问题][navicat_ 2002-can_t connect to server on localhost_10061_mysql]  
4.[ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)][ERROR 2003 _HY000_ Can_t connect to MySQL server on _localhost_ _10061]

[f14c48d21b624858a10f44670b5ef6f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/210be992f70f48769452d094f08ff798.png
[75bd960462d14d4cab5ab7dfab96ccac.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/96bed801adf6419a841ad21eb25c6fe3.png
[67ea87a26f8b479299fd064a364be9f9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/abde19a0b2a0484ea1210a522b764d8f.png
[dab7469c6aed4471bb65568550e2dd9f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/b2dbc70696444960b4f445cf846843e6.png
[7dbbd2527acb413fbad33341765ff3e5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/bb455a8c4d494241a3746449288e6758.png
[0080df6ab3cb4897912e1a20deaad8b8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/2a11ab9205444f92a114470dcd249f22.png
[3017dbb7dc454c22957d38c4aec2224d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/8b19758db44848faa45bef0e8b297bfa.png
[MySQL_mysql_Windows]: https://blog.csdn.net/JustinQin/article/details/102644775
[MySQL_ERROR 1064 _42000_MySQL]: https://blog.csdn.net/weixin_45242865/article/details/118227786
[navicat_ 2002-can_t connect to server on localhost_10061_mysql]: https://blog.csdn.net/nzt337/article/details/122182744
[ERROR 2003 _HY000_ Can_t connect to MySQL server on _localhost_ _10061]: https://blog.csdn.net/huang6ing/article/details/103821495