use mysql;
查看一下
select * from user where User =‘mysql.infoschema’;
更新这个用户的权限
update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
刷新权限
flush privileges;
这下因为数据库权限的问题就修改完成了
use mysql;
查看一下
select * from user where User =‘mysql.infoschema’;
更新这个用户的权限
update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
刷新权限
flush privileges;
这下因为数据库权限的问题就修改完成了