ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
来源:互联网 发布:学unity3d还是虚幻4 编辑:程序博客网 时间:2024/05/17 13:07
一.问题描述
远程连接mysql数据库的时候报如下错误
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
perror 111
OS error code 111: Connection refused
##连接被拒绝
二.问题可能原因
1) 网络不通
通过 ping xxx.xxx.xx.xxx可以发现网络是否正常
2)查看数据库是否配置了bind_address参数
本地登录数据库查看my.cnf文件和数据库当前参数show variables like 'bind_address';
如果设置了bind_address=127.0.0.1 那么只能本地登录
3)查看数据库是否设置了skip_networking参数
如果设置了该参数,那么只能本地登录mysql数据库
4)端口指定是否正确
使用如下命令检查 某个ip的某个端口是否正常
telnet 192.168.57.101 3306
如上,如果3306端口是通的那么输出应该如下:
telnet 192.168.57.101 3306Trying 192.168.57.101...Connected to 192.168.57.101 (192.168.57.101).Escape character is '^]'.N5.6.26-log'H)1]_EyV!€~:D%.S;l/B@Xmysql_native_password
0 0
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061),错误代码2003
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX'
- SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'XXX\' (13)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (3)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xx.xx.xx.xx' (110)
- Mysql error number 2003 can't connect to mysql server on XXX(10061)
- Can't connect to MySQL server on 'xxx' (13)
- Can't connect to MySQL server on 'XXX' (13)
- Can't connect to Mysql server on xxx (10038)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- 2003 cant connect to MySQL server on 'XXX.XXX.XXX.XXX'
- php程序mysql Can't connect to MySQL server on 'XXX' (13)错误解决办法
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- 【linux】Can't connect to MySQL server on 'XXX' (13)问题解决方式
- Hibernate4 注解方法中所有的字段含义
- openGL 笔记
- mongodb安装与启动关闭
- Photoshop中图层叠加效果的算法
- OC语言使用“消息结构”(messaging structure)而非“函数调用”(function calling)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
- Android 自定义View -- 简约的折线图
- 本地图片加载
- 通过AudioManager 设置调整系统各项音量(铃声 媒体等)
- Eclipse Class Decompiler——Java反编译插件
- 基于RTP的FEC前向丢错算法简介
- Android Design Support Library(二)用NavigationView实现抽屉菜单界面
- 定义一个函数,在该函数中可以实现任意两个整数的加法。java实现
- JavaScript练习二之Tabs