Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7.
Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver compatible with the caching_sha2_password for Rocky Linux 8 (EL8 or OL8 compatible).
Therefore, I build two new packages supporting the latest perl-DBD-MySQL driver, version 5.005.
The difference is related to the version of libmysql they are linked to.
libmysql.so.21 for MySQL 8.0 and libmysql.so.24 for MySQL 8.4 LTS:
MySQL 8.0
$ rpm -qf /usr/lib64/mysql/libmysqlclient.so.21
mysql-community-libs-8.0.37-1.el8.x86_64
$ ldd /usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so | grep libmysql
libmysqlclient.so.21 => /usr/lib64/mysql/libmysqlclient.so.21MySQL 8.4
$ rpm -qf /usr/lib64/mysql/libmysqlclient.so.24
mysql-community-libs-8.4.0-1.el8.x86_64
$ ldd /usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so | grep libmysql
libmysqlclient.so.24 => /usr/lib64/mysql/libmysqlclient.so.24Here are the two rpm packages:
Enjoy connecting to MySQL using Perl and thank you to Daniël van Eeden for maintaining the driver.
