Yum update failed on CloudLinux with mysql conflicts

Symptoms

When updating system packages, you encounter conflicts similar to the following.

file /etc/my.cnf conflicts between attempted installs of cl-MariaDB103-libs-10.3.39-4.el7.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-2.el7.cloudlinux.x86_64
file /lib64/security/pam_user_map.so conflicts between attempted installs of cl-MariaDB103-libs-10.3.39-4.el7.cloudlinux.x86_64 and cl-MariaDB105-server-10.5.22-2.el7.cloudlinux.x86_64
file /usr/share/mysql/czech/errmsg.sys conflicts between attempted installs of cl-MariaDB103-libs-10.3.39-4.el7.cloudlinux.x86_64 and cl-MariaDB105-server-10.5.22-2.el7.cloudlinux.x86_64
file /usr/share/mysql/danish/errmsg.sys conflicts between attempted installs of cl-MariaDB103-libs-10.3.39-4.el7.cloudlinux.x86_64 and cl-MariaDB105-server-10.5.22-2.el7.cloudlinux.x86_64

Description

The issue is due to compatibility issues with the mysqlclient18-compat package. CloudLinux is reviewing this issue in their internal ticket, CLOS-1955.

Workaround

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Run the following command

   rpm -e --nodeps mysqlclient18-compat

   dnf clean all