MySQL Workbench warning when connecting to MariaDB
CenOS에 MariaDB 설치 후 remote 열기
|
1 2 3 4 5 |
cd /etc/my.cnf.d # ls client.cnf enable_encryption.preset mysql-clients.cnf server.cnf tokudb.cnf |
|
1 2 3 4 5 6 |
#sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf bind-address=0.0.0.0 |
3306 포트 열기
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[root@localhost my.cnf.d]# cat /etc/sysconfig/iptables # sample configuration for iptables service # you can edit this manually or use system-config-firewall # please do not ask us to add additional ports/services to this default configuration *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [0:0] -A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT -A INPUT -p icmp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT -A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT -A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT -A INPUT -j REJECT --reject-with icmp-host-prohibited -A FORWARD -j REJECT --reject-with icmp-host-prohibited COMMIT |
ubuntu ufw root 계정 리모트(%) 가능 으로 변경 (10.5 이하에서만 가능) MariaDB 10.5 […]