Re: DBD::MariaDB and caching_sha2_password in Windows

Hello Matteo,

Could you try to specify "mariadb_auth_plugin=caching_sha2_password"
connection option? See the documentation for example:

https://metacpan.org/pod/DBD::MariaDB#mariadb_auth_plugin

Also could you provide us more information about your setup, for example
what is the client library which you used for compiling DBD::MariaDB? It
can be verified by checking the $dbh->{mariadb_clientinfo} content:

https://metacpan.org/pod/DBD::MariaDB#mariadb_clientinfo

Pali

On Thursday 11 December 2025 10:23:12 Matteo Bottazzi wrote:
> Hi guys,
> 
> May I ask you what should I do to let the 'caching_sha2_password' authentication method work in Windows?
> In my setup I have Strawberry Perl 5.32.1, DBD::MariaDB 1.24, MySQL 8.4.7, MySQL Connector/C++ 9.5.
> 
> I already tried to reinstall the DBD::MariaDB module using the latest libraries from MySQL 8.4.7 but it didn't work.
> 
> Could you please advise?
> I keep getting the error "DBI connect('database=v17_epvzparser_1;host=127.0.0.1;port=3308','epv',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: Impossibile trovare il modulo specificato.".
> The connection is made like this:
> my $dbh = DBI->connect("DBI:MariaDB:database=$DBNAME;host=$MYHOST;port=$MYPORT", $MYUSER, $MYPSWD) or die "Connection error: $DBI::errstr";
> 
> Many thanks for you help!
> 
> Best Regards
> 
> Matteo Bottazzi
>