mysql Access denied for user ‘root’@’%’ to database

项目场景：mysql Access denied for user ‘root’@’%’ to database ‘’

安装的mysql5.7：添加账号及权限
例如：
create user ‘用户名’@’%’ IDENTIFIED by ‘密码’;
flush privileges;
grant ALL PRIVILEGES on 库名.* to 用户@’%’;

---

提示：
mysql Access denied for user ‘root’@’%’ to database ‘库名’

---

原因分析：

root或登录账号无权限
查看mysql嘻嘻：
SELECT host,user,authentication_string,Grant_priv,Super_privFROM mysql.user;

主要查看
Grant_priv,Super_priv
如果是N修改为Y即可

---

解决方案：

修改权限即可：UPDATE mysql.user SET Grant_priv=‘Y’, Super_priv=‘Y’ WHERE User=‘root’;
FLUSH PRIVILEGES;