1、IP或port不一致;
2、用户没有权限;
select * from user;
有时会查询失败,切换下表即可
show tables;
rename user 'root'@'localhost' to 'root'@'%';
alter user 'root'@'%' identified by 'root';
create user 'test'@'%' identified by 'test123456';(密码最低安全性要求:长度不少于8位;必须包含数字)
grant all on *.* to 'test'@'%';
select user,host from user;
3、CentOS7 防火墙拦截
查询端口号是否开启:
firewall-cmd --query-port=3306/tcp
查询有哪些端口号开启的:
firewall-cmd --list-port
开启防火墙端口号:
firewall-cmd --zone=public --add-port = 3306/tcp --permanent
重启防火墙:
firewall-cmd --reload
关闭防火墙:
systemctl stop firewalld