View ‘information_schema.SCHEMATA‘ references invalid table(s) or column(s) or function(s) or define

use mysql; 查看一下 select * from user where User =‘mysql.infoschema’; 更新这个用户的权限 up

use mysql;
查看一下
select * from user where User =‘mysql.infoschema’;
在这里插入图片描述
更新这个用户的权限
update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
刷新权限
flush privileges;

这下因为数据库权限的问题就修改完成了