Yeah, version 4.053 is outdated. I’d recommend deleting these CPAN modules and using the dnf install perl-DBD-mysql command to get the latest version that won’t set the parameter causing an error.
The protocol is the same, but the MariaDB version of the driver is maintained by the MariaDB team and reportedly aims to match MariaDB features better.