问题:
MySQL登录后,使用Show tables/databases;等命令报错,信息如下:
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
解决方法:
查询了网上的方法,使用如下方式解决个人本次错误:
CREATE USER 'mysql.infoschema'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'mysql.infoschema'@'%';
FLUSH PRIVILEGES;