Unable to install the "DBD::mysql" Perl module

Symptoms

Attempting to install the "DBD::mysql" Perl module in WHM fails with the following.

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 's3kr1t';
mysql> GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost';

You can also optionally set the user to run 'make test' with:

perl Makefile.PL --testuser=username

N/A
1 distribution installed
cpanminus failed with non-zero exit status: 1

All available perl module install methods have failed

Description

This issue occurs when an SQL server other than MySQL 8 is installed due to the "DBD::mysql" module requiring MySQL 8.x. Servers running MariaDB 10.x or MySQL 5.x must install the "perl-DBD-MySQL" package.

Workaround

1. Log into WHM as root.
2. Navigate to "WHM / Software / Install Distro Packages."
3. Search for the Perl DBD-MySQL library package.
   • Enterprise-Linux systems:

     perl-DBD-MySQL

   • Ubuntu systems:

     libdbd-mysql-perl

4. Only one result should be presented. Click install on the desired package.