开启MYSQL远程连接权限

 

 

 

开启MYSQL远程连接权限

 

1 2 3 4 5

//建议设置固定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