ERROR 2003 (HY000): Can't connect to MySQL server on '172.27.9.252' (110 "Connection timed out")
来源:互联网 发布:域名国外 编辑:程序博客网 时间:2024/06/16 07:50
新安装了MariaDB,本机能够连接,但是无法远程连接:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘172.27.9.252’ (110 “Connection timed out”)
[root@moxiaokai ~]# mysql -h 127.0.0.1 -uroot -pEnter password: Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 12Server version: 10.1.13-MariaDB Source distributionCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.[root@moxiaokai ~]# mysql -h 172.27.9.252 -uroot -pEnter password: ERROR 2003 (HY000): Can't connect to MySQL server on '172.27.9.252' (110 "Connection timed out")[root@moxiaokai mydata]# perror 111OS error code 111: Connection refused
问题分析:
1.排除网络问题(127.0.0.1能够访问)
2.排除防火墙问题(防火墙已关闭)
3.检查日志(无错误日志)
4.排查配置问题(检查/etc/my.cnf)
根本原因:
数据库配置问题,没有启用[client],在/etc/my.cnf配置文件中添加以下配置,重启数据库。
[client]port = 3306socket = /data/sdv1/mydata/mariadb.sock
阅读全文
1 0
- ERROR 2003 (HY000): Can't connect to MySQL server on '172.27.9.252' (110 "Connection timed out")
- ERROR 2003 (HY000): Can't connect to MySQL server on
- ERROR 2003 (HY000): Can't connect to MySQL server on '***.**.***.***' (110)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xx.xx.xx.xx' (110)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- 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)
- 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 'localhost' (10061)
- mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 常见问题:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- 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)的解决
- es6 import 和 export细节说明
- 修改Ubuntu默认的MySQL表名大小写区分
- spring事物配置,声明式事务管理和基于@Transactional注解的使用
- 创建守护进程为什仫要fork两次
- Vue.js 入门
- ERROR 2003 (HY000): Can't connect to MySQL server on '172.27.9.252' (110 "Connection timed out")
- 手机生成ODEX提升开机速度的原因
- C# Chart控件的使用总结
- 百度地图实现路线规划
- liunx 配置tomcat
- Spring Boot + gradle环境搭建
- 颜色模式
- Cocos2dx 使用Shader使精灵变灰
- Mac 下 java 连接数据库