linux mysql 授权以及 iptables开启3306

分类: IT文章 • 2022-08-31 18:10:11

mysql授权ip段访问mysql

grant all privileges on *.* to 'yang'@'192.168.1.%' identified  by '123456';

linux iptables开启3306端口访问

iptables -I INPUT -p tcp -s 192.168.1.0/24  --dport 3306 -j ACCEPT
/etc/init.d/iptables save