赞
踩
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,成功
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。