- 查看用户表,发现目标用户存在且密码正确
select user,host,authentication_string from mysql.user;
- 查看授权,发现为空
show grants for 'user'@'host';
- 给账号进行授权,并刷新权限
grant select on *.* to 'user'@'host' identified by 'password';
flush privileges;
select user,host,authentication_string from mysql.user;
show grants for 'user'@'host';
grant select on *.* to 'user'@'host' identified by 'password';
flush privileges;