使用docker compose升级出现失败

GDLiuXin

以下是MySQL报错的日志

2026-02-05 06:22:03+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.40-1.el7 started.
2026-02-05 06:22:03+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
command was: mysqld --default-authentication-plugin=caching_sha2_password --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --verbose --help --log-bin-index=/tmp/tmp.gXZWJHi0QY
2026-02-05T06:22:03.591547Z 0 [ERROR] Can't start server: Invalid value for --default-authentication-plugin
2026-02-05T06:22:03.661047Z 0 [ERROR] Aborting
2026-02-05 06:22:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.40-1.el7 started.
2026-02-05 06:22:04+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
command was: mysqld --default-authentication-plugin=caching_sha2_password --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --verbose --help --log-bin-index=/tmp/tmp.PjwuzqK0W3
2026-02-05T06:22:04.214911Z 0 [ERROR] Can't start server: Invalid value for --default-authentication-plugin
2026-02-05T06:22:04.216879Z 0 [ERROR] Aborting
2026-02-05 06:22:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.40-1.el7 started.
2026-02-05 06:22:04+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
command was: mysqld --default-authentication-plugin=caching_sha2_password --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --verbose --help --log-bin-index=/tmp/tmp.CBxUs0n4Ng
2026-02-05T06:22:04.688179Z 0 [ERROR] Can't start server: Invalid value for --default-authentication-plugin
2026-02-05T06:22:04.690625Z 0 [ERROR] Aborting
2026-02-05 06:22:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.40-1.el7 started.
2026-02-05 06:22:05+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
command was: mysqld --default-authentication-plugin=caching_sha2_password --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --verbose --help --log-bin-index=/tmp/tmp.AILSBocXaF
2026-02-05T06:22:05.360980Z 0 [ERROR] Can't start server: Invalid value for --default-authentication-plugin
2026-02-05T06:22:05.363624Z 0 [ERROR] Aborting

败犬

GDLiuXin 将 mysql 升级到 8.x 版本。

HaoUp

你在升级过程中，可能更新了 docker-compose.yaml 文件，使用了 Halo 官方最新的配置文件模板（官方最新模板通常默认适配 MySQL 8.0），但你的 image 镜像版本或者本地数据依然保留的是 MySQL 5.7。这就导致用 8.0 的命令去启动 5.7 的数据库，从而报错。