有两步:
1、开放授权
# mysql -u root -p
mysql-> grant all privileges on *.* to root@'%' identified by '123' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql-> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql-> exit
2、设置防火墙,/etc/sysconfig/iptables
将
-A INPUT -p tcp -m tcp --dport 3306 -j DROP
修改为
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
3、最后,重启mysql服务即可。