首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >MySQL8.0错误-如何运行mysql_upgrade

MySQL8.0错误-如何运行mysql_upgrade
EN

Stack Overflow用户
提问于 2022-07-01 12:17:07
回答 1查看 588关注 0票数 0

在我的开发机器(Ubuntu20.04,mysql 8.0.29-0ubuntu0.20.04.3)上,我的笔记本电脑需要关闭,因为mysql没有启动。

我有这样的腐败错误:

代码语言:javascript
运行
复制
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:

代码语言:javascript
运行
复制
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。我能做些什么来解决这个问题?

谢谢。

EN

回答 1

Stack Overflow用户

发布于 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开始:

  1. 关闭服务器并安装新的二进制文件
  2. 启动服务器,让服务器升级数据字典表和系统表。

有关更多细节,请阅读我链接到的文章。

您可能必须强制MySQL服务器将升级应用于表,方法是使用本文中提到的mysqld --upgrade=FORCE。另一个用户报告必须执行该here

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/72829142

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档