in reply to Re^5: plugin 'mysql_old_password' cannot be loaded
in thread plugin 'mysql_old_password' cannot be loaded

The output with my 5.24 perl is 
OS         : MSWin32
Perl       : v5.24.0
DBD::MySQL : 4.033
Server     : 5.5.53-0+deb7u1-log

[download]
With the portable 5.28 perl (and a few changes in the code) 
OS         : MSWin32
Perl       : v5.28.1
DBD::MySQL :
DBI connect('...:3306',...,...) failed: Authentication plugin 'mysql_o
+ld_password' cannot be loaded: The specified module could not be foun
+d.
 at get_version.pl line 21.

[download]

Replies are listed 'Best First'.
Re^7: plugin 'mysql_old_password' cannot be loaded
by marto (Cardinal) on Feb 19, 2019 at 08:01 UTC
[reply]
Re^7: plugin 'mysql_old_password' cannot be loaded
by poj (Abbot) on Feb 19, 2019 at 09:09 UTC

    Is the perl 5.24 also portable strawberry and is it on the same machine as your new 5.28 ?

    poj
[reply]

      5.24 is a normal setup.

      Both 5.28 + 5.24 are on the same pc.

      And I had to rename the folder where 5.24 is to hide it from the path.

      I tried to change the line that set the path in the bat that run 5.28 but without success (the window did not stay open)

      F

[reply]

        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
[reply]
[d/l]

In Section Seekers of Perl Wisdom