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

root@localhost 10:25:39 [(none)]>show databases ;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
root@localhost 10:25:43 [(none)]>alter user root@'localhost' identified by 'Root@0101';
ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist

mysql5.7升级到８.０后，再用5.7程序开启mysql，会报这样错误。

处理方法：

SET GLOBAL innodb_fast_shutdown = 0; -- slow shutdown

mysql_upgrade -uroot -pRoot@0101

 

mysql_upgrade ：　增加的权限和使新增功能能被使用