MySQL 8 Community Edition 설치 중 오류

아마존 리눅스 환경에서 MySQL 8 Community Edition 설치 중 다음과 같은 오류가 발생했다.

Error: 

 Problem: conflicting requests

  - nothing provides libcrypto.so.10()(64bit) needed by mysql-community-server-8.0.11-1.el7.x86_64

  - nothing provides libssl.so.10()(64bit) needed by mysql-community-server-8.0.11-1.el7.x86_64

  - nothing provides libcrypto.so.10(libcrypto.so.10)(64bit) needed by mysql-community-server-8.0.11-1.el7.x86_64

......

  - nothing provides libssl.so.10(libssl.so.10)(64bit) needed by mysql-community-server-8.0.36-1.el7.x86_64
  - nothing provides libcrypto.so.10(OPENSSL_1.0.2)(64bit) needed by mysql-community-server-8.0.36-1.el7.x86_64
(try to add '--skip-broken' to skip uninstallable packages)

 

원인 : Amazon Linux 2 에서 지원하지 않는 버전의 레포지토리를 설치했기 때문이다.

(이전 버전 레포지토리)

 

아마존 리눅스 2023을 쓸 때는 el9 버전 레포지토리를 사용해주어야 한다고 한다!

 

기존 코드 :

wget dev.mysql.com/get/mysql80-commuity-release-e17-5.noarch.rpm
rpm -ivh mysql-community-release-e17.5.noarch.rpm

 

el9 버전 코드 :

sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm
sudo dnf install mysql-community-server

이렇게 작성하시면 잘 설치 됩니다.

 

 

🚨 만약에 해당 에러가 뜬다면, 이 에러는 MySQL 패키지가 제공된 GPG 키와 일치하지 않아서 발생한다.

이 문제를 해결하려면 MySQL GPG 키를 가져와서 시스템에 추가해야 한다.

MySQL 8.0 Community Server                                                                                                       3.0 MB/s | 3.1 kB     00:00    
GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 (0x3A79BD29) is already installed
The GPG keys listed for the "MySQL 8.0 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.. Failing package is: mysql-community-client-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-client-plugins-8.0.36-1.el9.x86_64.rpm is not installed. Failing package is: mysql-community-client-plugins-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-common-8.0.36-1.el9.x86_64.rpm is not installed. Failing package is: mysql-community-common-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-icu-data-files-8.0.36-1.el9.x86_64.rpm is not installed. Failing package is: mysql-community-icu-data-files-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-libs-8.0.36-1.el9.x86_64.rpm is not installed. Failing package is: mysql-community-libs-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-server-8.0.36-1.el9.x86_64.rpm is not installed. Failing package is: mysql-community-server-8.0.36-1.el9.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'dnf clean packages'.
Error: GPG check FAILED

 

-> GPG 키를 연결해주자.

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

이후 다시 재설치해주면!

sudo dnf install mysql-community-server

 

이렇게 GPG KEY를 다시 받아오고 yum update 하는 과정을 해준 뒤 업데이트 하면 해결된다!

 

$ sudo systemctl status mysqld

로 잘 깔렸는지 체크해주자.