http://qs1969.pair.com?node_id=11117454


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

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.