ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist

问题：

mysql> use sk;Database changedmysql> show tables;ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

总体办法就是给 mysql.infoschema 用户添加权限。

MySQL8.0 之后，不支持使用 grant 时隐式地创建用户，必须先创建用户，再授权

解决：

mysql> create user 'mysql.infoschema'@'%' identified by '密码';Query OK, 0 rows affected (0.01 sec)mysql> grant all privileges on *.* to 'mysql.infoschema'@'%';Query OK, 0 rows affected (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)