MySQL SHOW命令报错 ERROR 1449 (HY000)

mysql> SHOW DATABASES;
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';

删除

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

创建

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

授权

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

刷新

flush privileges;