打開防火墻配置文件
vim /etc/sysconfig/iptables
增加以下防火墻規(guī)則
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT ?
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
重啟防火墻服務(wù)器
service iptables restart?
修改mysql遠程訪問權(quán)限命令
mysql -u root -proot
grant?all?privileges?on?*.*?to?'root'@'%'?identified?by?'123456'?with?grant?option;
flush?privileges;
