1.第一步关闭防火墙
systemctl stop firewalld
2.查询use表中的信息
select Host,user from mysql.user;
3.修改root的允许权限
update mysql.user set Host='%' where user='rooot';
4.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'#修改localhost 为%
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
5.最后重启mysql服务
systemctl restart mysqld