无法在centos7上远程访问mysql/mariadb

qyyhg6bp  于 2021-06-24  发布在  Mysql
关注(0)|答案(1)|浏览(579)

我试图远程访问我的mysql/mariadb服务器,但它一直拒绝我的访问。以下是我的设置:
iptables-l

  1. Chain INPUT (policy ACCEPT)
  2. target prot opt source destination
  3. ACCEPT tcp -- anywhere anywhere tcp dpt:mysql
  4. ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED
  5. ACCEPT all -- anywhere anywhere
  6. INPUT_direct all -- anywhere anywhere
  7. INPUT_ZONES_SOURCE all -- anywhere anywhere
  8. INPUT_ZONES all -- anywhere anywhere
  9. DROP all -- anywhere anywhere ctstate INVALID
  10. REJECT all -- anywhere anywhere reject-with icmp-host-prohibited

mysql数据库

  1. MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';
  2. +----------+------+
  3. | User | Host |
  4. +----------+------+
  5. | feed_user| % |
  6. +----------+------+

我的.cnf

  1. [mysqld]
  2. local-infile=0
  3. datadir=/var/lib/mysql
  4. socket=/var/lib/mysql/mysql.sock
  5. symbolic-links=0
  6. [mysqld_safe]
  7. log-error=/var/log/mariadb/mariadb.log
  8. pid-file=/var/run/mariadb/mariadb.pid
  9. !includedir /etc/my.cnf.d

netstat-plnt

  1. Active Internet connections (only servers)
  2. Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
  3. tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 30227/mysqld

服务器在我的本地网络中,在不同的子网中。
内部防火墙设置为允许两个子网之间的连接,可以看到正在接受的流量。
你知道为什么它不允许我远程访问吗?
谢谢克里斯

kiz8lqtg

kiz8lqtg1#

原来我是在给iptables添加规则,而不是防火墙。在将规则添加到firewalld之后,我可以远程访问服务器。

相关问题