今日はなにの日。

気になったこと勉強になったことのメモ。

今日は、GPGキーを更新してMySQL8.0.28をインストールするの日。

目次

とある日

現在(2022年1月18日 )MySQLがインストールできない人向けです。

GPGキーの更新をしないと正しくインストールされないようです。

bugs.mysql.com

公式のリリースノートにも本件について記載がありました。

MySQL :: MySQL 8.0 Release Notes :: Changes in MySQL 8.0.28 (2022-01-18, General Availability)

MySQLのダウンロード可能なパッケージの署名に使用されるGnuPGビルドキーが更新されました。以前のGnuPGビルドキーは2022-02-16に期限切れになるように設定されています。GnuPG署名チェックを使用してMySQLダウンロード可能パッケージの整合性と信頼性を検証する方法、または公開GnuPGビルドキーのコピーを取得する方法については、GnuPGを使用した署名チェックを参照してください。

解決策

そのままコマンドコピーするとうまく行かないです。フォントの関係だと思われます。

新しいGPGキーを使用することを忘れないでください:$𝚜𝚞𝚍𝚘𝚛𝚙𝚖--𝚒𝚖𝚙𝚘𝚛𝚝𝚑𝚝𝚝𝚙𝚜://𝚛𝚎𝚙𝚘.𝚖𝚢𝚜𝚚𝚕.𝚌𝚘𝚖/𝚁𝙿𝙼-𝙶𝙿𝙶-𝙺𝙴𝚈-𝚖𝚢𝚜𝚚𝚕-𝟸0𝟸𝟸

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

実行してインストールし直すだけ。

検証

DockerでCentOS7の環境で行います。

Docker構築

MySQL :: MySQL 8.0 リファレンスマニュアル :: 2.5.1 MySQL Yum リポジトリを使用して MySQL を Linux にインストールする

DockerでCentOS 7のイメージを利用してみよう |

PS C:\Users\81902> docker run -it -d --name mysql8028 centos:centos7
e2b28129cd0e3437b8467ed2b058b90b47f85e8590ed4d914ad6ec2f3a064bdf
PS C:\Users\81902> docker ps
CONTAINER ID   IMAGE                  COMMAND                  CREATED         STATUS         PORTS                       NAMES
e2b28129cd0e   centos:centos7         "/bin/bash"              6 seconds ago   Up 5 seconds                               mysql8028
faaacf261e1d   kindest/node:v1.21.1   "/usr/local/bin/entr…"   4 months ago    Up 31 hours    127.0.0.1:40115->6443/tcp   kind-control-plane
PS C:\Users\81902>  docker exec -it mysql8028 /bin/bash
[root@e2b28129cd0e /]# ll

MySQLインストール(失敗)

インストール手順は過去の記事を参考にしました。

updraft.hatenadiary.com

[root@e2b28129cd0e /]# rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
Retrieving https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
warning: /var/tmp/rpm-tmp.P9oSNU: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql80-community-release-el7-1  ################################# [100%]
[root@e2b28129cd0e /]# sudo yum repolist enabled | grep "mysql.*-community.*"
bash: sudo: command not found
[root@e2b28129cd0e /]#  yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64       MySQL Connectors Community          230
mysql-tools-community/x86_64            MySQL Tools Community               138
mysql80-community/x86_64                MySQL 8.0 Community Server          321
[root@e2b28129cd0e /]# yum install mysql-community-server
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: ftp.yz.yamagata-u.ac.jp
 * extras: ftp.yz.yamagata-u.ac.jp
 * updates: ftp.yz.yamagata-u.ac.jp
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.28-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: /usr/bin/perl for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: perl(strict) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1()(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package mysql-community-client.x86_64 0:8.0.28-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.28-1.el7 for package: mysql-community-client-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.28-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package numactl-libs.x86_64 0:2.0.12-5.el7 will be installed
---> Package perl.x86_64 4:5.16.3-299.el7_9 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-299.el7_9.x86_64
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Running transaction check
---> Package mysql-community-client-plugins.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.28-1.el7 will be installed
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-macros.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-299.el7_9 will be installed
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: groff-base for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package groff-base.x86_64 0:1.22.2-8.el7 will be installed
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================================================================================================
 Package                                                      Arch                                 Version                                                 Repository                                       Size
=================================================================================================================================================================================================================
Installing:
 mysql-community-server                                       x86_64                               8.0.28-1.el7                                            mysql80-community                               451 M
Installing for dependencies:
 groff-base                                                   x86_64                               1.22.2-8.el7                                            base                                            942 k
 libaio                                                       x86_64                               0.3.109-13.el7                                          base                                             24 k
 mysql-community-client                                       x86_64                               8.0.28-1.el7                                            mysql80-community                                53 M
 mysql-community-client-plugins                               x86_64                               8.0.28-1.el7                                            mysql80-community                               5.7 M
 mysql-community-common                                       x86_64                               8.0.28-1.el7                                            mysql80-community                               630 k
 mysql-community-icu-data-files                               x86_64                               8.0.28-1.el7                                            mysql80-community                               2.1 M
 mysql-community-libs                                         x86_64                               8.0.28-1.el7                                            mysql80-community                               4.7 M
 net-tools                                                    x86_64                               2.0-0.25.20131004git.el7                                base                                            306 k
 numactl-libs                                                 x86_64                               2.0.12-5.el7                                            base                                             30 k
 perl                                                         x86_64                               4:5.16.3-299.el7_9                                      updates                                         8.0 M
 perl-Carp                                                    noarch                               1.26-244.el7                                            base                                             19 k
 perl-Encode                                                  x86_64                               2.51-7.el7                                              base                                            1.5 M
 perl-Exporter                                                noarch                               5.68-3.el7                                              base                                             28 k
 perl-File-Path                                               noarch                               2.09-2.el7                                              base                                             26 k
 perl-File-Temp                                               noarch                               0.23.01-3.el7                                           base                                             56 k
 perl-Filter                                                  x86_64                               1.49-3.el7                                              base                                             76 k
 perl-Getopt-Long                                             noarch                               2.40-3.el7                                              base                                             56 k
 perl-HTTP-Tiny                                               noarch                               0.033-3.el7                                             base                                             38 k
 perl-PathTools                                               x86_64                               3.40-5.el7                                              base                                             82 k
 perl-Pod-Escapes                                             noarch                               1:1.04-299.el7_9                                        updates                                          52 k
 perl-Pod-Perldoc                                             noarch                               3.20-4.el7                                              base                                             87 k
 perl-Pod-Simple                                              noarch                               1:3.28-4.el7                                            base                                            216 k
 perl-Pod-Usage                                               noarch                               1.63-3.el7                                              base                                             27 k
 perl-Scalar-List-Utils                                       x86_64                               1.27-248.el7                                            base                                             36 k
 perl-Socket                                                  x86_64                               2.010-5.el7                                             base                                             49 k
 perl-Storable                                                x86_64                               2.45-3.el7                                              base                                             77 k
 perl-Text-ParseWords                                         noarch                               3.29-4.el7                                              base                                             14 k
 perl-Time-HiRes                                              x86_64                               4:1.9725-3.el7                                          base                                             45 k
 perl-Time-Local                                              noarch                               1.2300-2.el7                                            base                                             24 k
 perl-constant                                                noarch                               1.27-2.el7                                              base                                             19 k
 perl-libs                                                    x86_64                               4:5.16.3-299.el7_9                                      updates                                         690 k
 perl-macros                                                  x86_64                               4:5.16.3-299.el7_9                                      updates                                          44 k
 perl-parent                                                  noarch                               1:0.225-244.el7                                         base                                             12 k
 perl-podlators                                               noarch                               2.5.1-3.el7                                             base                                            112 k
 perl-threads                                                 x86_64                               1.87-4.el7                                              base                                             49 k
 perl-threads-shared                                          x86_64                               1.43-6.el7                                              base                                             39 k

Transaction Summary
=================================================================================================================================================================================================================
Install  1 Package (+36 Dependent packages)

Total download size: 530 M
Installed size: 2.5 G
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/base/packages/libaio-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Public key for libaio-0.3.109-13.el7.x86_64.rpm is not installed
(1/37): libaio-0.3.109-13.el7.x86_64.rpm                                                                                                                                                  |  24 kB  00:00:00
(2/37): groff-base-1.22.2-8.el7.x86_64.rpm                                                                                                                                                | 942 kB  00:00:00
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY     ] 6.6 MB/s | 8.0 MB  00:01:19 ETA
Public key for mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm is not installed
(3/37): mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm                                                                                                                            | 5.7 MB  00:00:00
(4/37): mysql-community-common-8.0.28-1.el7.x86_64.rpm                                                                                                                                    | 630 kB  00:00:00
(5/37): mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm                                                                                                                            | 2.1 MB  00:00:00
(6/37): mysql-community-libs-8.0.28-1.el7.x86_64.rpm                                                                                                                                      | 4.7 MB  00:00:00
(7/37): numactl-libs-2.0.12-5.el7.x86_64.rpm                                                                                                                                              |  30 kB  00:00:00
(8/37): perl-Carp-1.26-244.el7.noarch.rpm                                                                                                                                                 |  19 kB  00:00:00
(9/37): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm                                                                                                                                     | 306 kB  00:00:00
(10/37): perl-Exporter-5.68-3.el7.noarch.rpm                                                                                                                                              |  28 kB  00:00:00
(11/37): perl-File-Path-2.09-2.el7.noarch.rpm                                                                                                                                             |  26 kB  00:00:00
(12/37): perl-File-Temp-0.23.01-3.el7.noarch.rpm                                                                                                                                          |  56 kB  00:00:00
(13/37): perl-Filter-1.49-3.el7.x86_64.rpm                                                                                                                                                |  76 kB  00:00:00
(14/37): perl-Getopt-Long-2.40-3.el7.noarch.rpm                                                                                                                                           |  56 kB  00:00:00
(15/37): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                                                                                                                            |  38 kB  00:00:00
(16/37): perl-PathTools-3.40-5.el7.x86_64.rpm                                                                                                                                             |  82 kB  00:00:00
Public key for perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm is not installed                 8% [======-                                                                         ]  10 MB/s |  43 MB  00:00:46 ETA
(17/37): perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm                                                                                                                                       |  52 kB  00:00:00
(18/37): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                                                                                                                                           |  87 kB  00:00:00
(19/37): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                                                                                                                            | 216 kB  00:00:00
(20/37): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                                                                                                                             |  27 kB  00:00:00
(21/37): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm                                                                                                                                   |  36 kB  00:00:00
(22/37): perl-Socket-2.010-5.el7.x86_64.rpm                                                                                                                                               |  49 kB  00:00:00
(23/37): perl-Storable-2.45-3.el7.x86_64.rpm                                                                                                                                              |  77 kB  00:00:00
(24/37): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                                                                                                                                       |  14 kB  00:00:00
(25/37): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm                                                                                                                                          |  45 kB  00:00:00
(26/37): perl-Time-Local-1.2300-2.el7.noarch.rpm                                                                                                                                          |  24 kB  00:00:00
(27/37): perl-constant-1.27-2.el7.noarch.rpm                                                                                                                                              |  19 kB  00:00:00
(28/37): perl-libs-5.16.3-299.el7_9.x86_64.rpm                                                                                                                                            | 690 kB  00:00:01
(29/37): perl-macros-5.16.3-299.el7_9.x86_64.rpm                                                                                                                                          |  44 kB  00:00:00
(30/37): perl-parent-0.225-244.el7.noarch.rpm                                                                                                                                             |  12 kB  00:00:00
(31/37): perl-podlators-2.5.1-3.el7.noarch.rpm                                                                                                                                            | 112 kB  00:00:00
(32/37): perl-threads-1.87-4.el7.x86_64.rpm                                                                                                                                               |  49 kB  00:00:00
(33/37): perl-threads-shared-1.43-6.el7.x86_64.rpm                                                                                                                                        |  39 kB  00:00:00
(34/37): perl-Encode-2.51-7.el7.x86_64.rpm                                                                                                                                                | 1.5 MB  00:00:04
(35/37): mysql-community-client-8.0.28-1.el7.x86_64.rpm                                                                                                                                   |  53 MB  00:00:06
(36/37): perl-5.16.3-299.el7_9.x86_64.rpm                                                                                                                                                 | 8.0 MB  00:00:06
(37/37): mysql-community-server-8.0.28-1.el7.x86_64.rpm                                                                                                                                   | 451 MB  00:00:22
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                             22 MB/s | 530 MB  00:00:24
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Importing GPG key 0xF4A80EB5:
 Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"
 Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
 Package    : centos-release-7-9.2009.0.el7.centos.x86_64 (@CentOS)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Is this ok [y/N]: y
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql80-community-release-el7-1.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y


Public key for mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm is not installed


 Failing package is: mysql-community-client-plugins-8.0.28-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

ここですね。

Public key for mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm is not installed

Failing package is: mysql-community-client-plugins-8.0.28-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

↓翻訳

mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm の公開鍵はインストールされていない。

失敗したパッケージは: mysql-community-client-plugins-8.0.28-1.el7.x86_64 GPG キーは次のように設定されています: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

GPGキー更新

[root@e2b28129cd0e /]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@e2b28129cd0e /]#

特に何も表示されないです。

MySQL再インストール

[root@e2b28129cd0e /]# yum install mysql-community-server
Loaded plugins: fastestmirror, ovl
Loading mirror speeds from cached hostfile
 * base: ftp.yz.yamagata-u.ac.jp
 * extras: ftp.yz.yamagata-u.ac.jp
 * updates: ftp.yz.yamagata-u.ac.jp
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.28-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: /usr/bin/perl for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: perl(strict) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: libnuma.so.1()(64bit) for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package mysql-community-client.x86_64 0:8.0.28-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.28-1.el7 for package: mysql-community-client-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.28-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package numactl-libs.x86_64 0:2.0.12-5.el7 will be installed
---> Package perl.x86_64 4:5.16.3-299.el7_9 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-299.el7_9.x86_64
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Running transaction check
---> Package mysql-community-client-plugins.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.28-1.el7 will be installed
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-macros.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-299.el7_9 will be installed
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: groff-base for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package groff-base.x86_64 0:1.22.2-8.el7 will be installed
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================================================================================================
 Package                                                      Arch                                 Version                                                 Repository                                       Size
=================================================================================================================================================================================================================
Installing:
 mysql-community-server                                       x86_64                               8.0.28-1.el7                                            mysql80-community                               451 M
Installing for dependencies:
 groff-base                                                   x86_64                               1.22.2-8.el7                                            base                                            942 k
 libaio                                                       x86_64                               0.3.109-13.el7                                          base                                             24 k
 mysql-community-client                                       x86_64                               8.0.28-1.el7                                            mysql80-community                                53 M
 mysql-community-client-plugins                               x86_64                               8.0.28-1.el7                                            mysql80-community                               5.7 M
 mysql-community-common                                       x86_64                               8.0.28-1.el7                                            mysql80-community                               630 k
 mysql-community-icu-data-files                               x86_64                               8.0.28-1.el7                                            mysql80-community                               2.1 M
 mysql-community-libs                                         x86_64                               8.0.28-1.el7                                            mysql80-community                               4.7 M
 net-tools                                                    x86_64                               2.0-0.25.20131004git.el7                                base                                            306 k
 numactl-libs                                                 x86_64                               2.0.12-5.el7                                            base                                             30 k
 perl                                                         x86_64                               4:5.16.3-299.el7_9                                      updates                                         8.0 M
 perl-Carp                                                    noarch                               1.26-244.el7                                            base                                             19 k
 perl-Encode                                                  x86_64                               2.51-7.el7                                              base                                            1.5 M
 perl-Exporter                                                noarch                               5.68-3.el7                                              base                                             28 k
 perl-File-Path                                               noarch                               2.09-2.el7                                              base                                             26 k
 perl-File-Temp                                               noarch                               0.23.01-3.el7                                           base                                             56 k
 perl-Filter                                                  x86_64                               1.49-3.el7                                              base                                             76 k
 perl-Getopt-Long                                             noarch                               2.40-3.el7                                              base                                             56 k
 perl-HTTP-Tiny                                               noarch                               0.033-3.el7                                             base                                             38 k
 perl-PathTools                                               x86_64                               3.40-5.el7                                              base                                             82 k
 perl-Pod-Escapes                                             noarch                               1:1.04-299.el7_9                                        updates                                          52 k
 perl-Pod-Perldoc                                             noarch                               3.20-4.el7                                              base                                             87 k
 perl-Pod-Simple                                              noarch                               1:3.28-4.el7                                            base                                            216 k
 perl-Pod-Usage                                               noarch                               1.63-3.el7                                              base                                             27 k
 perl-Scalar-List-Utils                                       x86_64                               1.27-248.el7                                            base                                             36 k
 perl-Socket                                                  x86_64                               2.010-5.el7                                             base                                             49 k
 perl-Storable                                                x86_64                               2.45-3.el7                                              base                                             77 k
 perl-Text-ParseWords                                         noarch                               3.29-4.el7                                              base                                             14 k
 perl-Time-HiRes                                              x86_64                               4:1.9725-3.el7                                          base                                             45 k
 perl-Time-Local                                              noarch                               1.2300-2.el7                                            base                                             24 k
 perl-constant                                                noarch                               1.27-2.el7                                              base                                             19 k
 perl-libs                                                    x86_64                               4:5.16.3-299.el7_9                                      updates                                         690 k
 perl-macros                                                  x86_64                               4:5.16.3-299.el7_9                                      updates                                          44 k
 perl-parent                                                  noarch                               1:0.225-244.el7                                         base                                             12 k
 perl-podlators                                               noarch                               2.5.1-3.el7                                             base                                            112 k
 perl-threads                                                 x86_64                               1.87-4.el7                                              base                                             49 k
 perl-threads-shared                                          x86_64                               1.43-6.el7                                              base                                             39 k

Transaction Summary
=================================================================================================================================================================================================================
Install  1 Package (+36 Dependent packages)

Total size: 530 M
Installed size: 2.5 G
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : mysql-community-common-8.0.28-1.el7.x86_64                                                                                                                                                   1/37
  Installing : mysql-community-client-plugins-8.0.28-1.el7.x86_64                                                                                                                                           2/37
  Installing : mysql-community-libs-8.0.28-1.el7.x86_64                                                                                                                                                     3/37
  Installing : mysql-community-client-8.0.28-1.el7.x86_64                                                                                                                                                   4/37
  Installing : numactl-libs-2.0.12-5.el7.x86_64                                                                                                                                                             5/37
  Installing : libaio-0.3.109-13.el7.x86_64                                                                                                                                                                 6/37
  Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                    7/37
  Installing : groff-base-1.22.2-8.el7.x86_64                                                                                                                                                               8/37
  Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                           9/37
  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                           10/37
  Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                           11/37
  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                          12/37
  Installing : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                                                                                                                                    13/37
  Installing : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                               14/37
  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                      15/37
  Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                            16/37
  Installing : 4:perl-macros-5.16.3-299.el7_9.x86_64                                                                                                                                                       17/37
  Installing : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                             18/37
  Installing : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                             19/37
  Installing : perl-constant-1.27-2.el7.noarch                                                                                                                                                             20/37
  Installing : perl-Socket-2.010-5.el7.x86_64                                                                                                                                                              21/37
  Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                         22/37
  Installing : perl-Carp-1.26-244.el7.noarch                                                                                                                                                               23/37
  Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                       24/37
  Installing : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                            25/37
  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                                  26/37
  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                         27/37
  Installing : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                       28/37
  Installing : perl-threads-1.87-4.el7.x86_64                                                                                                                                                              29/37
  Installing : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                               30/37
  Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                         31/37
  Installing : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                            32/37
  Installing : 4:perl-libs-5.16.3-299.el7_9.x86_64                                                                                                                                                         33/37
  Installing : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                          34/37
  Installing : 4:perl-5.16.3-299.el7_9.x86_64                                                                                                                                                              35/37
  Installing : mysql-community-icu-data-files-8.0.28-1.el7.x86_64                                                                                                                                          36/37
  Installing : mysql-community-server-8.0.28-1.el7.x86_64                                                                                                                                                  37/37
  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                            1/37
  Verifying  : mysql-community-client-plugins-8.0.28-1.el7.x86_64                                                                                                                                           2/37
  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                        3/37
  Verifying  : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                              4/37
  Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                              5/37
  Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                                                                              6/37
  Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                             7/37
  Verifying  : mysql-community-icu-data-files-8.0.28-1.el7.x86_64                                                                                                                                           8/37
  Verifying  : perl-Socket-2.010-5.el7.x86_64                                                                                                                                                               9/37
  Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                          10/37
  Verifying  : 4:perl-macros-5.16.3-299.el7_9.x86_64                                                                                                                                                       11/37
  Verifying  : groff-base-1.22.2-8.el7.x86_64                                                                                                                                                              12/37
  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                         13/37
  Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                   14/37
  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                         15/37
  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                         16/37
  Verifying  : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                                                                                                                                    17/37
  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                          18/37
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                                                                                                                                19/37
  Verifying  : mysql-community-client-8.0.28-1.el7.x86_64                                                                                                                                                  20/37
  Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                                                                               21/37
  Verifying  : mysql-community-common-8.0.28-1.el7.x86_64                                                                                                                                                  22/37
  Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                       23/37
  Verifying  : mysql-community-libs-8.0.28-1.el7.x86_64                                                                                                                                                    24/37
  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                                  25/37
  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                            26/37
  Verifying  : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                               27/37
  Verifying  : mysql-community-server-8.0.28-1.el7.x86_64                                                                                                                                                  28/37
  Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                           29/37
  Verifying  : 4:perl-5.16.3-299.el7_9.x86_64                                                                                                                                                              30/37
  Verifying  : numactl-libs-2.0.12-5.el7.x86_64                                                                                                                                                            31/37
  Verifying  : perl-threads-1.87-4.el7.x86_64                                                                                                                                                              32/37
  Verifying  : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                               33/37
  Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                          34/37
  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                      35/37
  Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                            36/37
  Verifying  : 4:perl-libs-5.16.3-299.el7_9.x86_64                                                                                                                                                         37/37

Installed:
  mysql-community-server.x86_64 0:8.0.28-1.el7

Dependency Installed:
  groff-base.x86_64 0:1.22.2-8.el7                libaio.x86_64 0:0.3.109-13.el7                          mysql-community-client.x86_64 0:8.0.28-1.el7    mysql-community-client-plugins.x86_64 0:8.0.28-1.el7
  mysql-community-common.x86_64 0:8.0.28-1.el7    mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7    mysql-community-libs.x86_64 0:8.0.28-1.el7      net-tools.x86_64 0:2.0-0.25.20131004git.el7
  numactl-libs.x86_64 0:2.0.12-5.el7              perl.x86_64 4:5.16.3-299.el7_9                          perl-Carp.noarch 0:1.26-244.el7                 perl-Encode.x86_64 0:2.51-7.el7
  perl-Exporter.noarch 0:5.68-3.el7               perl-File-Path.noarch 0:2.09-2.el7                      perl-File-Temp.noarch 0:0.23.01-3.el7           perl-Filter.x86_64 0:1.49-3.el7
  perl-Getopt-Long.noarch 0:2.40-3.el7            perl-HTTP-Tiny.noarch 0:0.033-3.el7                     perl-PathTools.x86_64 0:3.40-5.el7              perl-Pod-Escapes.noarch 1:1.04-299.el7_9
  perl-Pod-Perldoc.noarch 0:3.20-4.el7            perl-Pod-Simple.noarch 1:3.28-4.el7                     perl-Pod-Usage.noarch 0:1.63-3.el7              perl-Scalar-List-Utils.x86_64 0:1.27-248.el7
  perl-Socket.x86_64 0:2.010-5.el7                perl-Storable.x86_64 0:2.45-3.el7                       perl-Text-ParseWords.noarch 0:3.29-4.el7        perl-Time-HiRes.x86_64 4:1.9725-3.el7
  perl-Time-Local.noarch 0:1.2300-2.el7           perl-constant.noarch 0:1.27-2.el7                       perl-libs.x86_64 4:5.16.3-299.el7_9             perl-macros.x86_64 4:5.16.3-299.el7_9
  perl-parent.noarch 1:0.225-244.el7              perl-podlators.noarch 0:2.5.1-3.el7                     perl-threads.x86_64 0:1.87-4.el7                perl-threads-shared.x86_64 0:1.43-6.el7

Complete!
[root@e2b28129cd0e /]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@e2b28129cd0e /]# mysql --version
mysql  Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

正しく最新バージョンがインストールされていることを確認できました。

たまたまMySQL構築しててできなくて困っててツイッター見てたら見つけたので誰がの助けになればと思い作成しました。

よきMySQLライフを。