错误场景

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

查询是否有这个账户

select user,host from mysql.user where user='mysql.infoschema';

查看这个账户的权限

show grants for 'mysql.infoschema'@'localhost';

删除这个mysql.infoschema

DROP USER 'mysql.infoschema'@'localhost';

创建mysql.infoschema

CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';

授权

GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;