mariadb无法远程访问的解决思路

1、安装完成mariadb，已经配置远程访问权限：

+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| %             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+------+-------------------------------------------+
2、而其他主机远程访问时，结果出现如下报错：

ERROR 2003 (HY000): Can't connect to MySQL server on '10.60.38.13 (111)

3、尝试ping mariadb所在主机：

PING 10.60.38.13 (10.60.38.13) 56(84) bytes of data.
64 bytes from 10.60.38.13: icmp_seq=1 ttl=128 time=45.2 ms
64 bytes from 10.60.38.13: icmp_seq=2 ttl=128 time=45.3 ms
^C
--- 10.60.38.13 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1001ms

rtt min/avg/max/mdev = 45.249/45.287/45.325/0.038 ms

4、再通过telnet访问3306端口，发现不通

5、检查防火墙没有对3306端口进行任何限制

6、netstat检查3306端口占用情况

root@cdp:~# netstat -anpt | grep 3306

tcp6       0      0 127.0.0.0:3306                 :::*                    LISTEN      26273/mysqld

说明中招了，mariadb只监听了本地127.0.0.1的地址。

7、修改配置文件，注释bind-address

配置文件地址：/etc/mysql/mariadb.conf.d/50-server.cnf

8、重启mariadb

systemctl restart mysql

9、再次远程访问mariadb，成功