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

Re: DBI Connection Fails with Access Denied on one version of Perl/DBD::MySQL and work on the other

by derby (Abbot)
on May 29, 2020 at 11:01 UTC ( #11117454=note: print w/replies, xml ) Need Help??


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

This is a nice tough one. Out of curiosity, does your db password have any special characters in it? If so, you may want to use single quotes when setting it

my $pass = 'PASS_REMOVED';

Also, it's probably not going to shed any light but instead of $! when failing, use $DBI::errstr

Good Luck!

-derby
  • Comment on Re: DBI Connection Fails with Access Denied on one version of Perl/DBD::MySQL and work on the other
  • Select or Download Code

Replies are listed 'Best First'.
Re^2: 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 14:43 UTC
    Good point, I did see another post talking about a similar issue with special characters, so I did check for that. The password is alphanumeric.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11117454]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2021-03-04 04:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favorite kind of desktop background is:











    Results (98 votes). Check out past polls.

    Notices?