在我的开发机器(Ubuntu20.04,mysql 8.0.29-0ubuntu0.20.04.3)上,我的笔记本电脑需要关闭,因为mysql没有启动。
我有这样的腐败错误:
2022-07-01T12:13:08.666633Z 0 [Warning] [MY-013139] [Server] Cannot load from
mysql.proxies_priv. The table is probably corrupted!
2022-07-01T12:13:08.666748Z 0 [ERROR] [MY-010316] [Server] Fatal error: Could not
read the column 'authentication_string' from table 'mysql.user'. Please perform the
MySQL upgrade procedure.
2022-07-01T12:13:08.666825Z 0 [ERROR] [MY-010952] [Server] The privilege system
failed to initialize correctly. For complete instructions on how to upgrade MySQL to
a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2022-07-01T12:13:08.667187Z 0 [ERROR] [MY-010119] [Server] Aborting
不过,我很乐意运行mysql_upgrade:
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.
这个版本似乎不支持mysql_upgrade。我能做些什么来解决这个问题?
谢谢。
发布于 2022-07-01 14:46:33
https://dev.mysql.com/blog-archive/mysql-8-0-16-mysql_upgrade-is-going-away/说:
从MySQL 8.0.16开始:
有关更多细节,请阅读我链接到的文章。
您可能必须强制MySQL服务器将升级应用于表,方法是使用本文中提到的mysqld --upgrade=FORCE
。另一个用户报告必须执行该here。
https://stackoverflow.com/questions/72829142
复制相似问题