问题描述:
使用MySQL中的SHOW DATABASES命令报错:ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist在网上找到的解决办法myql_upgrade -u root -p;(此方法在低版本的可用),我的mysql的版本是8.0.22,所有又爆出以下错误:
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
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 automatical