Ubuntu20在mysql8中解决 The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist

在终端运行如下：

/usr/sbin/mysqld --upgrade=NONE

进入mysql

use mysql;
select Host,user,authentication_string,plugin from user;

mysql5.7的插件为“mysql_native_password”
而mysql8.0的密码插件是caching_sha2_password

更新两条数据的plugin

update user set plugin = 'caching_sha2_password' where user='mysql.sys' or user='mysql.infoschema';
exit

重启mysql

service mysql restart