MySQL远程访问报错ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111)
来源:互联网 发布:物联网与人工智能 编辑:程序博客网 时间:2024/06/06 02:00
从一台linux远程连接另一台linux上的MySQL,
mysql -hxxx.xxx.xxx.xxx -uroot -p
出现ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx'(111)错误。
分析问题,应该是远程链接数据库连不上,直接想到的是3种可能:网络问题,端口问题,数据库配置问题。
首先检查网络:能ping通;
其次检查端口:是常规的3306端口
netstat -tunlp |grep mysqldtcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 4144/mysqld
最后检查配置/etc/mysql/my.cnf :
是否有配置skip_networking: 这使MySQL只能通过本机Socket连接(socket连接也是本地连接的默认方式),放弃对TCP/IP的监听,当然也不让本地java程序连接MySQL。——没有这个配置。
是否有配置bind_address=127.0.0.1(当然也可以是其他ip),这种情况可以指定TCP/IP连接 。有这个配置,把它注销掉,重启mysql。
再访问mysql -hxxx.xxx.xxx.xxx -uroot -p,成功登入。
阅读全文
0 0
- MySQL远程访问报错ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111)
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can\'t connect to MySQL server on\'XXXXX\'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- 【linux错误解决】MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- 数据库连接时 报错 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- (笔记)远程连接MySQL出现ERROR 2003 (HY000): Can't connect to MySQL server on ip (111)
- 连接mysql报错:error 2003 (hy000):can't connect to mysql server on 'localhost' (10061)
- yii2 gridview使用问题解决
- 一个程序猿的工作五年的总结和感悟!与君共勉!
- equals和==的区别
- PHP进程间通信
- 如何区别聚合支付“一清二清”?
- MySQL远程访问报错ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111)
- MyEclipse+Tomcat+MAVEN+SVN项目完整环境搭建
- Spring注入属性值 以及context-param参数介绍
- 学习4:创建ros工作空间和ROS包
- 好文链接:JavaScript深入系列15篇
- 设置的crontab脚本无法启动、关闭tomcat解决
- 【编码】unicode、ucs-2、ucs-4、utf-16、utf-32、utf-8 介绍
- BOZJ 2427: [HAOI2010]软件安装 树形背包
- WebApi跨域问题解决方案:CPRS