首先登陆mysql
mysql -u root -p ${your password}
use mysql;
select host, user, authentication_string, plugin from user;
#如果没有host=%的,说明没有启用远程登陆的账户
update user set host='%' where user='root';
#给远程账户授权
Grant all privileges on root.* to 'root'@'%';
#设置密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '${your password}';
#刷新权限
flush privileges;
exit;
这一顿操作下来就好了
Ps:请确认开启防火墙3306端口的访问权限
#查看端口
firewall-cmd --list-ports
#开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
#重启防火墙
firewall-cmd --reload