MySQL 1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server

1. 查看用户表，发现目标用户存在且密码正确

select user,host,authentication_string from mysql.user;

2. 查看授权，发现为空

show grants for 'user'@'host';

3. 给账号进行授权，并刷新权限

grant select on *.* to 'user'@'host' identified by 'password';
flush privileges;