And while we are on the subject, here is the corresponding code to use that config file:

my $dbh = DBI->connect(
   'DBI:mysql:database:host:mysql_read_default_file=~/.my.cnf',
   undef,undef,
   {RaiseError=>1}
);
[download]

Big thanks to gmax for introducing me to the MySQL config file (and that code) a while back. :)

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)