Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

[SOLVED-ISH]DBI Connection Fails with Access Denied on one version of Perl/DBD::MySQL and work on the other

by varneraa (Acolyte)
on May 29, 2020 at 05:29 UTC ( [id://11117445]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!/STANDARDINSTALLPATHTHATWORKS/5.26.1/bin/perl
    use strict;
    ...
    my $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
    DBI->trace(2);
    my $dbh = DBI->connect($dsn, $user, $pass) or die("Failed to connect t
    +o DB: $!");
    
  2. or download this
        DBI 1.643-nothread default trace level set to 0x0/2 (pid 87123 pi 
    +0) at dbtest line 20
        -> DBI->connect(DBI:mysql:database=DB_REPLACED;host=HOSTNAME_REPLA
    +CED;port=PORT_REPLACED, USER_REPLACED, ****, HASH(0x9094f0))
    ...
        <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 
    +758
    !   -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0xce
    +2e38)~INNER)
    !   <- DESTROY= ( undef ) [1 items] during global destruction
    
  3. or download this
        DBI 1.639-nothread default trace level set to 0x0/2 (pid 87340 pi 
    +0) at old_dbtest line 20
        -> DBI->connect(DBI:mysql:database=DB_REPLACED;host=HOSTNAME_REPLA
    +CED;port=PORT_REPLACED, USER_REPLACED, ****)
    ...
        <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 
    +755
    !   -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x9a
    +c9f8)~INNER)
    !   <- DESTROY= ( undef ) [1 items] during global destruction
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://11117445]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2024-06-22 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.