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

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

poj
  • Comment on Re^7: plugin 'mysql_old_password' cannot be loaded

Replies are listed 'Best First'.
Re^8: plugin 'mysql_old_password' cannot be loaded
by frazap (Monk) on Feb 19, 2019 at 09:34 UTC

    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

      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; }

      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
        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.
        We don't have the same version of the DBD::mysql driver.

        F.