Conflicting requests Error during installing MySQL in Amazon Linux EC2 Instance

Problem:

[ec2-user@ip-172-xx-xx-x~]$ sudo yum install mysql-community-server

MySQL 8.0 Community Server 34 MB/s | 3.0 MB 00:00

MySQL Connectors Community 3.8 MB/s | 59 kB 00:00

MySQL Tools Community 20 MB/s | 1.0 MB 00:00

Error:

Problem: conflicting requests

- nothing provides libcrypto.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()(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.11-1.el7.x86_64

…………………………………………………

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

(try to add '--skip-broken' to skip uninstallable packages)

Solution:

The reason this conflict occurs is because you installed a repository version of a repository that is not supported by Amazon Linux.For Amazon Linux 2023, enter the command below to install the EL9 version of the repository and mysql-community-server.

[ec2-user@ip-172-xx-xx-x~]$ sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm

Last metadata expiration check: 0:09:11 ago on Wed Oct 11 22:57:24 2023.

mysql80-community-release-el9-1.noarch.rpm 43 kB/s | 10 kB 00:00

Dependencies resolved.

=============================================================================================================================================================================================================================================

Package Architecture Version Repository Size

Upgrading:

mysql80-community-release noarch el9-1 @commandline 10 k

Transaction Summary

Upgrade 1 Package

Total size: 10 k

Is this ok [y/N]: y

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Upgrading : mysql80-community-release-el9-1.noarch 1/2

Cleanup : mysql80-community-release-el7-3.noarch 2/2

Verifying : mysql80-community-release-el9-1.noarch 1/2

Verifying : mysql80-community-release-el7-3.noarch 2/2

Upgraded:

mysql80-community-release-el9-1.noarch

Complete!

[ec2-user@ip-172-xx-xx-x~]$ sudo dnf install mysql-community-server

MySQL 8.0 Community Server 22 MB/s | 1.0 MB 00:00

MySQL Connectors Community 1.8 MB/s | 27 kB 00:00

MySQL Tools Community 11 MB/s | 366 kB 00:00

Dependencies resolved.

Package Architecture Version Repository Size

Installing:

mysql-community-server x86_64 8.0.34-1.el9 mysql80-community 49 M

Installing dependencies:

mysql-community-client x86_64 8.0.34-1.el9 mysql80-community 3.5 M

mysql-community-client-plugins x86_64 8.0.34-1.el9 mysql80-community 1.4 M

mysql-community-common x86_64 8.0.34-1.el9 mysql80-community 554 k

mysql-community-icu-data-files x86_64 8.0.34-1.el9 mysql80-community 2.3 M

mysql-community-libs x86_64 8.0.34-1.el9 mysql80-community 1.4 M

Transaction Summary

Install 6 Packages

Total download size: 58 M

Installed size: 334 M

Is this ok [y/N]: y

Downloading Packages:

(1/6): mysql-community-common-8.0.34-1.el9.x86_64.rpm 31 MB/s | 554 kB 00:00

(2/6): mysql-community-icu-data-files-8.0.34-1.el9.x86_64.rpm 53 MB/s | 2.3 MB 00:00

(3/6): mysql-community-client-8.0.34-1.el9.x86_64.rpm 39 MB/s | 3.5 MB 00:00

(4/6): mysql-community-libs-8.0.34-1.el9.x86_64.rpm 38 MB/s | 1.4 MB 00:00

(5/6): mysql-community-client-plugins-8.0.34-1.el9.x86_64.rpm 8.2 MB/s | 1.4 MB 00:00

(6/6): mysql-community-server-8.0.34-1.el9.x86_64.rpm 80 MB/s | 49 MB 00:00

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 82 MB/s | 58 MB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : mysql-community-common-8.0.34-1.el9.x86_64 1/6

Installing : mysql-community-client-plugins-8.0.34-1.el9.x86_64 2/6

Installing : mysql-community-libs-8.0.34-1.el9.x86_64 3/6

Running scriptlet: mysql-community-libs-8.0.34-1.el9.x86_64 3/6

Installing : mysql-community-client-8.0.34-1.el9.x86_64 4/6

Installing : mysql-community-icu-data-files-8.0.34-1.el9.x86_64 5/6

Running scriptlet: mysql-community-server-8.0.34-1.el9.x86_64 6/6

Installing : mysql-community-server-8.0.34-1.el9.x86_64 6/6

Running scriptlet: mysql-community-server-8.0.34-1.el9.x86_64 6/6

Verifying : mysql-community-client-8.0.34-1.el9.x86_64 1/6

Verifying : mysql-community-client-plugins-8.0.34-1.el9.x86_64 2/6

Verifying : mysql-community-common-8.0.34-1.el9.x86_64 3/6

Verifying : mysql-community-icu-data-files-8.0.34-1.el9.x86_64 4/6

Verifying : mysql-community-libs-8.0.34-1.el9.x86_64 5/6

Verifying : mysql-community-server-8.0.34-1.el9.x86_64 6/6

Installed:

mysql-community-client-8.0.34-1.el9.x86_64 mysql-community-client-plugins-8.0.34-1.el9.x86_64 mysql-community-common-8.0.34-1.el9.x86_64 mysql-community-icu-data-files-8.0.34-1.el9.x86_64 mysql-community-libs-8.0.34-1.el9.x86_64

mysql-community-server-8.0.34-1.el9.x86_64

Complete!