CentOS 7 开启3306端口MySQL可以远程连接

打开防火墙3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

1 2	firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload

或者禁用防火墙

systemctl stop firewalld.service
systemctl disable firewalld.service

1 2	systemctl stop firewalld.service systemctl disable firewalld.service

修改MySQL远程连接设置

mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; 
FLUSH PRIVILEGES;
EXIT

mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

FLUSH PRIVILEGES;

EXIT

如果您对C#游戏开发感兴趣，可以扫下面二维码加入我们的QQ群来一起学习交流

原创文章，转载请注明本文链接地址(违者必究):CentOS 7 开启3306端口MySQL可以远程连接