Sunday, October 4, 2020

Open firewall ports for MariaDB

 [root@unica12node1 unica]# telnet 192.168.1.162

Trying 192.168.1.162...

telnet: connect to address 192.168.1.162: No route to host


192.168.1.162 is my MariaDB DB server.

Enable port on DB server:

[root@database my.cnf.d]# systemctl start firewalld firewalld
[root@database my.cnf.d]# firewall-cmd --add-port=3306/tcp
success
[root@database my.cnf.d]# firewall-cmd --permanent --add-port=3306/tcp
success

Test again:
[root@unica12node1 unica]# telnet 192.168.1.162 3306
Trying 192.168.1.162...
Connected to 192.168.1.162.
Escape character is '^]'.
X
5.5.5-10.5.5-MariaDB%~p5U0-1▒▒!Nsz.oi>;MO'smysql_native_password^CConnection closed by foreign host.