解决Access denied for user 'root'@'%' to database 'xxx'

jdbc连接mysql出现
Access denied for user ‘root’@’%’ to database ‘xxx’

查看授权情况：SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
但是user=root, host=%, 权限都已经打开。

经过检查，发现上面命令显示的host=%, 有两条记录一条是user=root, host=%, 另一条是user=空，host=%,

把第二条user=空的记录删除，use mysql; delete from user where user=’’;

刷新：flush privileges;

然后重启mysql服务，service mysqld restart,

问题解决！