mysql-ERROR 1356

mysql 8.0.28版本、linux下

ERROR 1356 (HY000): View ‘information_schema.SCHEMATA’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

注意：查看information_schema.SCHEMATA模式’引用无效的表或列或函数，或者视图的定义者/调用者没有使用它们的权限

Select_priv：查询权限。

eg：

mysql> use mysql;

Database changed

mysql> select * from user where User ='mysql.infoschema'\G;

*************************** 1. row ***************************

                    Host: localhost

                    User: mysql.infoschema

                    Select_priv: N

mysql> update user set Select_priv = 'Y' where User = 'mysql.infoschema';

Query OK, 1 row affected (0.01 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)