Conflicts installing MariaDB over MySQL-8.0 (AlmaLinux)

$ podman run --name alma9 -d --rm --privileged  quay.io/almalinuxorg/9-init

$ podman exec -ti alma9  bash

 [root@d45f603a4248 /]# dnf install hostname mysql-server

AlmaLinux 9 - AppStream                                                                                                                        2.8 MB/s | 7.6 MB     00:02    

AlmaLinux 9 - BaseOS                                                                                                                           1.3 MB/s | 2.0 MB     00:01    

AlmaLinux 9 - Extras                                                                                                                            12 kB/s |  17 kB     00:01    

Dependencies resolved.

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

 Package                                              Architecture                   Version                                           Repository                         Size

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

Installing:

 hostname                                             x86_64                         3.23-6.el9                                        baseos                             27 k

 mysql-server                                         x86_64                         8.0.32-1.el9_2                                    appstream                          17 M

...

[root@d45f603a4248 /]# systemctl start mysqld.service

[root@d45f603a4248 /]# systemctl status mysqld.service

● mysqld.service - MySQL 8.0 database server

     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; preset: disabled)

     Active: active (running) since Fri 2023-06-09 01:15:50 UTC; 5s ago

    Process: 196 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)

    Process: 218 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)

   Main PID: 297 (mysqld)

     Status: "Server is operational"

      Tasks: 39 (limit: 1638)

     Memory: 457.4M

        CPU: 1.736s

     CGroup: /system.slice/mysqld.service

             └─297 /usr/libexec/mysqld --basedir=/usr

Jun 09 01:15:48 d45f603a4248 systemd[1]: Starting MySQL 8.0 database server...

Jun 09 01:15:48 d45f603a4248 mysql-prepare-db-dir[218]: Initializing MySQL database

Jun 09 01:15:50 d45f603a4248 systemd[1]: Started MySQL 8.0 database server.

[root@d45f603a4248 /]# journalctl -u mysqld.service

Jun 09 01:15:48 d45f603a4248 systemd[1]: Starting MySQL 8.0 database server...

Jun 09 01:15:48 d45f603a4248 mysql-prepare-db-dir[218]: Initializing MySQL database

Jun 09 01:15:50 d45f603a4248 systemd[1]: Started MySQL 8.0 database server.

[root@d45f603a4248 /]# cat /var/lib/mysql

mysql/         mysql-files/   mysql-keyring/ 

[root@d45f603a4248 /]# cat /var/lib/mysql/

#ib_16384_0.dblwr   auto.cnf            ca.pem              ibdata1             mysql.sock          mysqlx.sock.lock    server-cert.pem     undo_002

#ib_16384_1.dblwr   binlog.000001       client-cert.pem     ibtmp1              mysql.sock.lock     performance_schema/ server-key.pem      

#innodb_redo/       binlog.index        client-key.pem      mysql/              mysql_upgrade_info  private_key.pem     sys/                

#innodb_temp/       ca-key.pem          ib_buffer_pool      mysql.ibd           mysqlx.sock         public_key.pem      undo_001            

[root@d45f603a4248 /]# cat /var/log/mysql/mysqld.log 

2023-06-09T01:15:48.382181Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.32) initializing of server in progress as process 254

2023-06-09T01:15:48.384945Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2023-06-09T01:15:48.456071Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2023-06-09T01:15:49.188439Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

2023-06-09T01:15:50.389085Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.32) starting as process 297

2023-06-09T01:15:50.392064Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2023-06-09T01:15:50.445409Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2023-06-09T01:15:50.527623Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2023-06-09T01:15:50.527642Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2023-06-09T01:15:50.528962Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/run' in the path is accessible to all OS users. Consider choosing a different directory.

2023-06-09T01:15:50.537114Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock

2023-06-09T01:15:50.537123Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.32'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution.

[root@d45f603a4248 /]# cat > /etc/yum.repos.d/MariaDB.repo

# MariaDB 10.11 RedHatEnterpriseLinux repository list - created 2023-06-09 01:17 UTC

# https://mariadb.org/download/

[mariadb]

name = MariaDB

# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.

# baseurl = https://rpm.mariadb.org/10.11/rhel/$releasever/$basearch

baseurl = https://mirror.realcompute.io/mariadb/yum/10.11/rhel/$releasever/$basearch

# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB

gpgkey = https://mirror.realcompute.io/mariadb/yum/RPM-GPG-KEY-MariaDB

gpgcheck = 1

[root@d45f603a4248 /]# dnf update^C

[root@d45f603a4248 /]# dnf install MariaDB-server

MariaDB                                                                                                                                        1.5 MB/s | 690 kB     00:00    

Error: 

 Problem: package MariaDB-server-10.11.4-1.el9.x86_64 requires MariaDB-client >= 10.6.1, but none of the providers can be installed

  - package mysql-8.0.30-3.el9_0.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.2-1.el9.x86_64

  - package mysql-8.0.30-3.el9_0.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.3-1.el9.x86_64

  - package mysql-8.0.30-3.el9_0.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.4-1.el9.x86_64

  - problem with installed package mysql-8.0.32-1.el9_2.x86_64

  - package mysql-8.0.32-1.el9_2.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.2-1.el9.x86_64

  - package mysql-8.0.32-1.el9_2.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.3-1.el9.x86_64

  - package mysql-8.0.32-1.el9_2.x86_64 conflicts with mariadb provided by MariaDB-client-10.11.4-1.el9.x86_64

  - cannot install the best candidate for the job

(try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

[root@d45f603a4248 /]# dnf install --allowerasing MariaDB-server

Last metadata expiration check: 0:00:50 ago on Fri Jun  9 01:17:43 2023.

Dependencies resolved.

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

 Package                                          Architecture                      Version                                        Repository                             Size

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

Installing:

 MariaDB-server                                   x86_64                            10.11.4-1.el9                                  mariadb                                18 M

     replacing  mysql-server.x86_64 8.0.32-1.el9_2

Installing dependencies:

 MariaDB-client                                   x86_64                            10.11.4-1.el9                                  mariadb                               9.2 M

 MariaDB-common                                   x86_64                            10.11.4-1.el9                                  mariadb                                88 k

 MariaDB-shared                                   x86_64                            10.11.4-1.el9                                  mariadb                               130 k

     replacing  mariadb-connector-c-config.noarch 3.2.6-1.el9_0

 boost-program-options                            x86_64                            1.75.0-8.el9                                   appstream                             106 k

 daxctl-libs                                      x86_64                            71.1-8.el9                                     baseos                                 41 k

 galera-4                                         x86_64                            26.4.14-1.el9                                  mariadb                               1.3 M

 iproute                                          x86_64                            6.1.0-1.el9                                    baseos                                777 k

 libbpf                                           x86_64                            2:1.0.0-2.el9                                  baseos                                161 k

 libmnl                                           x86_64                            1.0.4-15.el9                                   baseos                                 28 k

 libpmem                                          x86_64                            1.12.1-1.el9                                   appstream                             111 k

 lsof                                             x86_64                            4.94.0-3.el9                                   baseos                                238 k

 ndctl-libs                                       x86_64                            71.1-8.el9                                     baseos                                 87 k

 perl-DBI                                         x86_64                            1.643-9.el9                                    appstream                             700 k

 perl-DynaLoader                                  x86_64                            1.47-480.el9                                   appstream                              26 k

 perl-File-Copy                                   noarch                            2.34-480.el9                                   appstream                              20 k

 perl-Math-BigInt                                 noarch                            1:1.9998.18-460.el9                            appstream                             188 k

 perl-Math-Complex                                noarch                            1.59-480.el9                                   appstream                              47 k

 perl-Sys-Hostname                                x86_64                            1.23-480.el9                                   appstream                              17 k

 psmisc                                           x86_64                            23.4-3.el9                                     baseos                                226 k

 rsync                                            x86_64                            3.2.3-19.el9                                   baseos                                393 k

 socat                                            x86_64                            1.7.4.1-5.el9                                  appstream                             300 k

Removing dependent packages:

 mysql                                            x86_64                            8.0.32-1.el9_2                                 @appstream                             60 M

Transaction Summary

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

Install  22 Packages

Remove    1 Package

Total download size: 32 M

Is this ok [y/N]: y

Downloading Packages:

(1/22): MariaDB-common-10.11.4-1.el9.x86_64.rpm                                                                                                487 kB/s |  88 kB     00:00    

(2/22): MariaDB-shared-10.11.4-1.el9.x86_64.rpm                                                                                                511 kB/s | 130 kB     00:00    

(3/22): galera-4-26.4.14-1.el9.x86_64.rpm                                                                                                      2.3 MB/s | 1.3 MB     00:00    

(4/22): boost-program-options-1.75.0-8.el9.x86_64.rpm                                                                                          238 kB/s | 106 kB     00:00    

(5/22): libpmem-1.12.1-1.el9.x86_64.rpm                                                                                                        1.0 MB/s | 111 kB     00:00    

(6/22): MariaDB-client-10.11.4-1.el9.x86_64.rpm                                                                                                5.6 MB/s | 9.2 MB     00:01    

(7/22): perl-DBI-1.643-9.el9.x86_64.rpm                                                                                                        2.8 MB/s | 700 kB     00:00    

(8/22): perl-File-Copy-2.34-480.el9.noarch.rpm                                                                                                 241 kB/s |  20 kB     00:00    

(9/22): perl-DynaLoader-1.47-480.el9.x86_64.rpm                                                                                                 98 kB/s |  26 kB     00:00    

(10/22): perl-Math-BigInt-1.9998.18-460.el9.noarch.rpm                                                                                         2.3 MB/s | 188 kB     00:00    

(11/22): perl-Sys-Hostname-1.23-480.el9.x86_64.rpm                                                                                             116 kB/s |  17 kB     00:00    

(12/22): perl-Math-Complex-1.59-480.el9.noarch.rpm                                                                                             171 kB/s |  47 kB     00:00    

(13/22): socat-1.7.4.1-5.el9.x86_64.rpm                                                                                                        1.9 MB/s | 300 kB     00:00    

(14/22): daxctl-libs-71.1-8.el9.x86_64.rpm                                                                                                     361 kB/s |  41 kB     00:00    

(15/22): iproute-6.1.0-1.el9.x86_64.rpm                                                                                                        3.1 MB/s | 777 kB     00:00    

(16/22): libmnl-1.0.4-15.el9.x86_64.rpm                                                                                                        598 kB/s |  28 kB     00:00    

(17/22): libbpf-1.0.0-2.el9.x86_64.rpm                                                                                                         477 kB/s | 161 kB     00:00    

(18/22): lsof-4.94.0-3.el9.x86_64.rpm                                                                                                          3.2 MB/s | 238 kB     00:00    

(19/22): psmisc-23.4-3.el9.x86_64.rpm                                                                                                          3.4 MB/s | 226 kB     00:00    

(20/22): ndctl-libs-71.1-8.el9.x86_64.rpm                                                                                                      548 kB/s |  87 kB     00:00    

(21/22): rsync-3.2.3-19.el9.x86_64.rpm                                                                                                         4.6 MB/s | 393 kB     00:00    

(22/22): MariaDB-server-10.11.4-1.el9.x86_64.rpm                                                                                               4.7 MB/s |  18 MB     00:03    

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

Total                                                                                                                                          5.3 MB/s |  32 MB     00:06     

MariaDB                                                                                                                                        116 kB/s |  15 kB     00:00    

Importing GPG key 0x1BB943DB:

 Userid     : "MariaDB Package Signing Key <package-signing-key@mariadb.org>"

 Fingerprint: 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB

 From       : https://mirror.realcompute.io/mariadb/yum/RPM-GPG-KEY-MariaDB

Is this ok [y/N]: y

Key imported successfully

Importing GPG key 0xC74CD1D8:

 Userid     : "MariaDB Signing Key <signing-key@mariadb.org>"

 Fingerprint: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8

 From       : https://mirror.realcompute.io/mariadb/yum/RPM-GPG-KEY-MariaDB

Is this ok [y/N]: y

Key imported successfully

Running transaction check

Transaction check succeeded.

Running transaction test

The downloaded packages were saved in cache until the next successful transaction.

You can remove cached packages by executing 'dnf clean packages'.

Error: Transaction test error:

  file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/armscii8.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/ascii.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp1250.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp1251.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp1256.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp1257.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp850.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp852.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/cp866.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/dec8.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/geostd8.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/greek.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/hebrew.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/hp8.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/keybcs2.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/koi8r.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/koi8u.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/latin1.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/latin2.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/latin5.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/latin7.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/macce.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/macroman.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/charsets/swe7.xml from install of MariaDB-common-10.11.4-1.el9.x86_64 conflicts with file from package mysql-common-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/bulgarian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/czech/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/danish/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/dutch/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/english/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/estonian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/french/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/german/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/greek/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/hungarian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/italian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/japanese/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/korean/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/norwegian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/polish/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/portuguese/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/romanian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/russian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/serbian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/slovak/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/spanish/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/swedish/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

  file /usr/share/mysql/ukrainian/errmsg.sys from install of MariaDB-server-10.11.4-1.el9.x86_64 conflicts with file from package mysql-errmsg-8.0.32-1.el9_2.x86_64

[root@d45f603a4248 /]#