数据库报错 RROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
MySQL8 误删除了几个用户,导致执行 show databases
都会出错
mysql> show databases; ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
修复办法呢,很简单,运行下面的语句
grant select on *.* TO 'mysql.infoschema'@'localhost';
然后就可以愉快的使用了
目前尚无回复