Amazon Linux 2023 の標準リポジトリ（AWS 提供の amzn repos）からは MySQL Server（8.4 を含む公式パッケージ）は提供されていません。
その代わり、MySQL の 公式 Yum リポジトリを追加してからインストールする方式 が一般的です。
インストール手順
インストール済みレポ確認
# dnf repolist
repo id repo name
amazonlinux Amazon Linux 2023 repository
kernel-livepatch Amazon Linux 2023 Kernel Livepatch repository
mysql-connectors-community MySQL Connectors Community
mysql-tools-community MySQL Tools Community
mysql80-community MySQL 8.0 Community Server
MySQL 8.4 レポを追加
# dnf -y install https://dev.mysql.com/get/mysql84-community-release-el9-1.noarch.rpm
# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
レポが追加されたか確認
# dnf repolist
repo id repo name
amazonlinux Amazon Linux 2023 repository
kernel-livepatch Amazon Linux 2023 Kernel Livepatch repository
mysql-8.4-lts-community MySQL 8.4 LTS Community Server
mysql-connectors-community MySQL Connectors Community
mysql-tools-8.4-lts-community MySQL Tools 8.4 LTS Community
8.4のパッケージがインストール可か確認
# dnf list --showduplicates mysql-community-server
Installed Packages
mysql-community-server.x86_64 8.0.43-1.el9 @mysql80-community
Available Packages
mysql-community-server.x86_64 8.4.0-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.2-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.3-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.4-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.5-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.6-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.7-1.el9 mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.8-1.el9 mysql-8.4-lts-community
アップデート前確認
# mysqld --version
/usr/sbin/mysqld Ver 8.0.43 for Linux on x86_64 (MySQL Community Server - GPL)
# mysql --version
mysql Ver 8.0.43 for Linux on x86_64 (MySQL Community Server - GPL)
# yum list installed | grep "mysql"
mysql-community-client.x86_64 8.0.43-1.el9 @mysql80-community
mysql-community-client-plugins.x86_64 8.0.43-1.el9 @mysql80-community
mysql-community-common.x86_64 8.0.43-1.el9 @mysql80-community
mysql-community-icu-data-files.x86_64 8.0.43-1.el9 @mysql80-community
mysql-community-libs.x86_64 8.0.43-1.el9 @mysql80-community
mysql-community-server.x86_64 8.0.43-1.el9 @mysql80-community
mysql84-community-release.noarch el9-1 @@commandline
php8.3-mysqlnd.x86_64 8.3.23-1.amzn2023.0.1 @amazonlinux
MySQL 8.0から8.4へアップデート
# dnf upgrade mysql-community-*
Upgraded:
mysql-community-client-8.4.8-1.el9.x86_64 mysql-community-client-plugins-8.4.8-1.el9.x86_64
mysql-community-common-8.4.8-1.el9.x86_64 mysql-community-icu-data-files-8.4.8-1.el9.x86_64
mysql-community-libs-8.4.8-1.el9.x86_64 mysql-community-server-8.4.8-1.el9.x86_64
アップデート後確認
# mysqld --version
/usr/sbin/mysqld Ver 8.4.8 for Linux on x86_64 (MySQL Community Server - GPL)
# mysql --version
mysql Ver 8.4.8 for Linux on x86_64 (MySQL Community Server - GPL)
# yum list installed | grep "mysql"
mysql-community-client.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql-community-client-plugins.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql-community-common.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql-community-icu-data-files.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql-community-libs.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql-community-server.x86_64 8.4.8-1.el9 @mysql-8.4-lts-community
mysql84-community-release.noarch el9-1 @@commandline
php8.3-mysqlnd.x86_64 8.3.23-1.amzn2023.0.1 @amazonlinux
設定確認
# vi /etc/my.cnf
起動
# systemctl start mysqld
# systemctl status mysqld
ログ確認
# cat /var/log/mysqld.log
念のため認証プラグイン確認
# mysql -u root -p
mysql> SELECT User, Host, Plugin FROM mysql.user;
mysql> use mysql;
mysql> show variables like 'default_authentication_plugin';