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

Run this program (with your credentials) on both old and new perls and post the results so we can see which versions you have.

#!/usr/bin/perl
use strict;
use DBI;

my $dbh = get_dbh();
my ($ver) = $dbh->selectrow_array('SELECT VERSION()');
printf "OS         : %s\n",$^O;
printf "Perl       : %s\n",$^V;
printf "DBD::MySQL : %s\n",$DBD::mysql::VERSION;
printf "Server     : %s\n",$ver;

sub get_dbh {

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

[download]
poj

Replies are listed 'Best First'.
Re^6: plugin 'mysql_old_password' cannot be loaded
by frazap (Monk) on Feb 19, 2019 at 07:47 UTC
    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]
[reply]
[d/l]
[select]
[reply]

      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]

In Section Seekers of Perl Wisdom