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
原创粉丝点击