mysql the user specified_Mysql Error:The user specified as a definer (‘mysql.infoschema’@’localhost’...

你好 我用了您的方法 在最后输入mysql_upgrade -u root -p后出现以下语句

D:\>cd D:\Program Files\mysql-8.0.21-winx64\mysql-8.0.21-winx64\bin

D:\Program Files\mysql-8.0.21-winx64\mysql-8.0.21-winx64\bin>mysql -u root -p

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 47

Server version: 8.0.21 MySQL Community Server – GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> SET GLOBAL innodb_fast_shutdown = 1;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

D:\Program Files\mysql-8.0.21-winx64\mysql-8.0.21-winx64\bin>mysql_upgrade -u root -p

Enter password: ****

The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.

To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.

The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the –upgrade=NONE option with the MySQL binary. The option –upgrade=FORCE is also provided to run the server upgrade sequence on demand.

It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the –upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.