ERROR 2003 (HY000): Can't connect to MySQL server on '172.27.9.252' (110 "Connection timed out")

新安装了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