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

问题：

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

• 1
• 2
• 3
• 4
• 5

总体办法就是给 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)