DBD::MariaDB and caching_sha2_password in Windows
[email protected] (Matteo Bottazzi) Thu, 11 Dec 2025 10:23:12 +0000
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <PA4P194MB1070054D9C8BB6860315C9CEAAA1A@PA4P194MB1070.EURP194.PROD.OUTLOOK.COM> |
--_000_PA4P194MB1070054D9C8BB6860315C9CEAAA1APA4P194MB1070EURP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi guys,
May I ask you what should I do to let the 'caching_sha2_password' authentic=
ation 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 libra=
ries from MySQL 8.4.7 but it didn't work.
Could you please advise?
I keep getting the error "DBI connect('database=3Dv17_epvzparser_1;host=3D1=
27.0.0.1;port=3D3308','epv',...) failed: Authentication plugin 'caching_sha=
2_password' cannot be loaded: Impossibile trovare il modulo specificato.".
The connection is made like this:
my $dbh =3D DBI->connect("DBI:MariaDB:database=3D$DBNAME;host=3D$MYHOST;por=
t=3D$MYPORT", $MYUSER, $MYPSWD) or die "Connection error: $DBI::errstr";
Many thanks for you help!
Best Regards
Matteo Bottazzi
--_000_PA4P194MB1070054D9C8BB6860315C9CEAAA1APA4P194MB1070EURP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
Hi guys,</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
May I ask you what should I do to let the 'caching_sha2_password' authentic=
ation method work in Windows?</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
In my setup I have Strawberry Perl 5.32.1, DBD::MariaDB 1.24, MySQL 8.4.7, =
MySQL Connector/C++ 9.5.</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
I already tried to reinstall the DBD::MariaDB module using the latest libra=
ries from MySQL 8.4.7 but it didn't work.</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
Could you please advise?</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
I keep getting the error "DBI connect('database=3Dv17_epvzparser_1;hos=
t=3D127.0.0.1;port=3D3308','epv',...) failed: Authentication plugin 'cachin=
g_sha2_password' cannot be loaded: Impossibile trovare il modulo specificat=
o.".</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
The connection is made like this: </div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
my $dbh =3D DBI->connect("DBI:MariaDB:database=3D$DBNAME;host=3D$MY=
HOST;port=3D$MYPORT", $MYUSER, $MYPSWD) or die "Connection error:=
$DBI::errstr";</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
Many thanks for you help!</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
Best Regards</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
Matteo Bottazzi</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
</body>
</html>
--_000_PA4P194MB1070054D9C8BB6860315C9CEAAA1APA4P194MB1070EURP_--