Chapter 3 升级 MySQL
Table of Contents
- 3.1 开始之前
- 3.2 升级路径
- 3.3 升级最佳实践
- 3.4 MySQL 升级过程升级的内容
- 3.5 MySQL 8.4 中的更改
- 3.6 准备升级安装
- 3.7 升级 MySQL Binary or Package-based Installations on Unix/Linux
- 3.8 升级 MySQL with the MySQL Yum Repository
- 3.9 升级 MySQL with the MySQL APT Repository
- 3.10 升级 MySQL with the MySQL SLES Repository
- 3.11 升级 MySQL on Windows
- 3.12 升级 Docker 安装的 MySQL
- 3.13 升级故障排除
- 3.14 Rebuilding or Repairing Tables or 索引
- 3.15 将 MySQL 数据库复制到另一台机器
This chapter describes the steps to upgrade a MySQL installation.
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.
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.
SQL statements can be executed using the mysql command-line client (connect as root
to ensure that you have the necessary privileges).