打开数据库
Use mysql;
查看权限表
select user,host from user;
修改或添加权限
#修改
grant all on *.* to 'root'@'%';
添加一个用户名为admin密码为123456的用户
grant all on *.* to admin@'%' identified by '123456' with grant option;
刷新权限
flush privileges;
最后查看linux防火墙设置,看是否开启了3306端口
firewall-cmd --list-all;