mysql开启远程连接(mysql开启远程访问)_MySQL
来源：动视网
责编：小采
时间：2020-11-09 18:52:30
mysql开启远程连接(mysql开启远程访问)_MySQL
mysql开启远程连接(mysql开启远程访问)_MySQL:bitsCN.com //建议设置固定IPmysql> GRANT ALL PRIVILEGES ON *.* TO root@8.8.8.8 IDENTIFIED BY root;mysql> flush privileges;//修改防火墙iptables -I INPUT -p tcp --dport 3306 -j ACCEPTbits
导读mysql开启远程连接(mysql开启远程访问)_MySQL:bitsCN.com //建议设置固定IPmysql> GRANT ALL PRIVILEGES ON *.* TO root@8.8.8.8 IDENTIFIED BY root;mysql> flush privileges;//修改防火墙iptables -I INPUT -p tcp --dport 3306 -j ACCEPTbits
bitsCN.com
//建议设置固定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
bitsCN.com
mysql开启远程连接(mysql开启远程访问)_MySQL
mysql开启远程连接(mysql开启远程访问)_MySQL:bitsCN.com //建议设置固定IPmysql> GRANT ALL PRIVILEGES ON *.* TO root@8.8.8.8 IDENTIFIED BY root;mysql> flush privileges;//修改防火墙iptables -I INPUT -p tcp --dport 3306 -j ACCEPTbits
