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

mysql好好的结果突然查库查表不行

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

试了许多办法之后下面一种方式对我有用，希望能帮助到大家
先照常用root用户登录到mysql
mysql -u root -p
然后
删除有问题的用户

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

再次创建这个用户

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

授予它权限

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

之后再次show databases;就没问题了