1、登录到 mysql :mysql -uroot -p
放开远程连接:Password输入自己数据库的密码;
(1)mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Password' WITH GRANT OPTION;
(2)刷新:FLUSH PRIVILEGES;
2、查看防火墙状态
[root@localhost ~]# firewall-cmd --state
关闭防火墙
[root@localhost ~]# systemctl stop firewalld.service
禁止开机启动
[root@localhost ~]# systemctl disable firewalld.service
3、连接测试成功,要关闭防火墙才可正常;
版权声明:本文为p1i2n3g4原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。