CentOS 7 Open 3306 port access

Tag:restart   systemctl   sql   stat    firewall configuration    install   c/s    Boot up    accept   

CentOS 7.0 defaults to using firewall as the firewall, where the iptables firewall is changed. 1. Close Firewall:systemctl Stop firewalld.servicesystemctl disable Firewalld.servicesystemctl mask Firewalld.service 2, Install iptables firewall yum install iptables-services-y3. Boot Settings Firewall # systemctl enable iptables# Systemctl start Iptables 4. View firewall status Systemctl status iptables5 Edit firewall, add Port vi/etc/sysconfig/iptables #编辑防火墙配置文件-A input-m State--state new-m tcp-p TC P--dport 22-j accept-a input-m State--state new-m tcp-p TCP--dport 80-j accept-a input-m State--state new-m TCP -P TCP--dport 3306-j accept:wq! #保存退出 3. Restart the configuration, restart the system systemctl restart Iptables.service #重启防火墙使配置生效systemctl enable Iptables.service #设置防火墙开机启动// Create a new MySQL user and authorize grant all privileges on * * to [email protected] identified by ' q123456 ';

CentOS 7 Open 3306 port access