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 >
