mysql_upgrade: [ERROR] 1449: 怎么解决？

C:\Users\lordwithme>mysql_upgrade -uroot -p123456
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1449: The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

https://www.jianshu.com/p/3231c19dbbe5

登陆
$ mysql -uroot -p12345678
$ mysql> show databases;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

修改
$ mysql> SET GLOBAL innodb_fast_shutdown = 1;
Query OK, 0 rows affected (0.01 sec)
$ mysql> quit
Bye

更新
$ mysql_upgrade -uroot -p12345678
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Upgrading system table data.
Checking system database.
mysql.columns_priv OK
mysql.component OK
……
yn.roles OK
yn.users OK
Upgrade process completed successfully.
Checking if update is needed.

再重新登陆就行了

楼上方法是对的