Re^9: plugin 'mysql_old_password' cannot be loaded

Try portable 5.24.0.1, download, unzip and run this script using portableshell.bat. Don't change the bat file.

!/usr/bin/perl
use strict;
use DBI;
use DBD::mysql;

printf "OS         : %s\n",$^O;
printf "Perl       : %s\n",$^V;
printf "DBD::mysql : %s\n",$DBD::mysql::VERSION;
print join "\n",@INC,"\n";

my $dbh = get_dbh();
my ($ver) = $dbh->selectrow_array('SELECT VERSION()');
printf "Server     : %s\n",$ver;

sub get_dbh {
  my $server = 'localhost';
  my $database = "pm"; 
  my $user = "user"; 
  my $pw   = "*****";
  my $dsn  = "dbi:mysql:$database:$server:3306"; 
  my $dbh  = DBI->connect($dsn, $user, $pw, 
     { RaiseError=>1, AutoCommit=>1 } );
  return $dbh;
}
[download]

I get

----------------------------------------------
 Welcome to Strawberry Perl Portable Edition!
 * URL - http://www.strawberryperl.com/
 * see README.TXT for more info
----------------------------------------------
Perl executable: D:\strawberry-perl-5.24.0.1-64bit-portable\perl\bin\perl.exe
Perl version   : 5.24.0 / MSWin32-x64-multi-thread

D:\strawberry-perl-5.24.0.1-64bit-portable>perl c:/temp/mysql.pl
OS         : MSWin32
Perl       : v5.24.0
DBD::MySQL : 4.033
D:/strawberry-perl-5.24.0.1-64bit-portable/perl/site/lib
D:/strawberry-perl-5.24.0.1-64bit-portable/perl/vendor/lib
D:/strawberry-perl-5.24.0.1-64bit-portable/perl/lib
.

Server     : 5.6.41

D:\strawberry-perl-5.24.0.1-64bit-portable>

poj

Comment on Re^9: plugin 'mysql_old_password' cannot be loaded Download Code

Replies are listed 'Best First'.
Re^10: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 19, 2019 at 12:07 UTC
`OS : MSWin32 Perl : v5.24.4 DBD::mysql : 4.046 C:/spp24/perl/site/lib C:/spp24/perl/vendor/lib C:/spp24/perl/lib . DBI connect('d...h:3306','d...m',...) failed: Authentication plugin 'm +ysql_old_password' cannot be loaded: The specified module could not be found. at get_version.pl line 24.` [download] We don't have the same version of the DBD::mysql driver. F.	[reply] [d/l]
Re^11: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 06:47 UTC
I tried to install the version 4.033 of DBD::mysql From cpan, the compilation failed because of missing header files. `dbdimp.c:36:20: fatal error: poll.h: No such file or directory # include <poll.h>` [download] Where can I get these ? Thanks F.	[reply] [d/l]
Re^12: plugin 'mysql_old_password' cannot be loaded by marto (Cardinal) on Feb 20, 2019 at 07:17 UTC
When installing a module and experiencing problems, expecially with old versions, it's important to check the changelog. See https://metacpan.org/changes/distribution/DBD-mysql#L230: `2016-10-14 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.037 +_01) * Newest versions of libmysqlclient and the MariaDB C connector no lon +ger export the __WIN__ macro. If this macro is not present we would not compile in the poll.h-based async-support. Changed to use the _WIN32 macro instead. Thanks to Sergei Golubchik for suggesting the fix.` [download] Also 0f4f5873168becf8b6640de68778b7406cd9a3d7, rt://68169.	[reply] [d/l]
Re^13: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 12:21 UTC
Re^14: plugin 'mysql_old_password' cannot be loaded by marto (Cardinal) on Feb 20, 2019 at 12:46 UTC
Some notes below your chosen depth have not been shown here


go ahead... be a heretic
	PerlMonks