Re^2: DBI->connect fails when password variable used

Thanks for the reply, Larry and I apologize for the delay getting back to you. That $passwd is a scalar. I've tried using, "connect($dsn,$user,$passwd)" as well as "connect("DBI:mysql:servers", "my uid", "mypasswd", {'RaiseError' => 1})" and the only thing that works is the hardcoded data as in the latter example. I've tried some of the other suggestions submitted without any luck so far. I would be happy to have the script prompt me for my password and be able to pass it in $passwd but haven't gotten that to work either. Thanks again for your suggestions. Fred

Comment on Re^2: DBI->connect fails when password variable used

Replies are listed 'Best First'.
Re^3: DBI->connect fails when password variable used by Corion (Patriarch) on Oct 27, 2014 at 15:41 UTC
How do you set `$passwd`? If you're reading the string from the user, most likely, that string still has a newline at its end, which you might want to remove: `$passwd =~ s/\s*$//; # Remove all whitespace from the end of the passw +ord` [download]	[reply] [d/l] [select]
Re^4: DBI->connect fails when password variable used by fmagee (Novice) on Aug 10, 2015 at 17:00 UTC
Thanks, Corion. That works like a champ.	[reply]