复制代码 代码如下: //建议设置固定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
复制代码 代码如下:
//建议设置固定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