复制代码 代码如下:

//建议设置固定IP

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"8.8.8.8" IDENTIFIED BY "root";

mysql> flush privileges;

//修改防火墙

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT