- 3.1 开始之前3.1 Before You Begin
- 3.2 升级路径3.2 Upgrade Paths
- 3.3 升级最佳实践3.3 Upgrade Best Practices
- 3.4 MySQL 升级过程是什么升级3.4 What the MySQL Upgrade Process Upgrades
- 3.5 MySQL 8.4 中的更改3.5 Changes in MySQL 8.4
- 3.6 准备安装以进行升级3.6 Preparing Your Installation for Upgrade
- 3.7 在 Unix/Linux 上升级 MySQL 二进制或基于包的安装3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux
- 3.8 使用 MySQL Yum 存储库升级 MySQL3.8 Upgrading MySQL with the MySQL Yum Repository
- 3.9 使用 MySQL APT 存储库升级 MySQL3.9 Upgrading MySQL with the MySQL APT Repository
- 3.10 使用 MySQL SLES 存储库升级 MySQL3.10 Upgrading MySQL with the MySQL SLES Repository
- 3.11 在 Windows 上升级 MySQL3.11 Upgrading MySQL on Windows
- 3.12 升级 Docker 安装的 MySQL3.12 Upgrading a Docker Installation of MySQL
- 3.13 升级故障排除3.13 Upgrade Troubleshooting
- 3.14 重建或修复表或索引3.14 Rebuilding or Repairing Tables or Indexes
- 3.15 将 MySQL 数据库复制到另一台计算机3.15 Copying MySQL Databases to Another Machine
本章介绍升级 MySQL 安装的步骤。This chapter describes the steps to upgrade a MySQL installation.
升级是一个常见的过程,因为您可以在同一 MySQL 版本系列中获取错误修复或在主要 MySQL 版本之间获取重要功能。您首先在一些测试系统上执行此过程,以确保一切顺利,然后在生产系统上执行。Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first on some test systems to make sure everything works smoothly, and then on the production systems.
在下面的讨论中,必须使用具有管理权限的 MySQL 帐户运行的 MySQL 命令包括命令行上的 -u
root 来指定 MySQL root 用户。需要 root 密码的命令还包含 -p 选项。由于 -p 后面没有选项值,因此此类命令会提示输入密码。出现提示时输入密码,然后按 Enter 键。In the following discussion, MySQL commands that must be run using
a MySQL account with administrative privileges include -u
on the command line to specify
the MySQL root root user. Commands that require a
password for root also include a
-p option. Because -p is
followed by no option value, such commands prompt for the
password. Type the password when prompted and press Enter.
可以使用 mysql 命令行客户端执行 SQL 语句(以 root 身份连接,以确保您拥有必要的权限)。SQL statements can be executed using the mysql
command-line client (connect as root to ensure
that you have the necessary privileges).