Re: Secure ways to use DBI?

If you're using MySQL, take a look at .my.cnf and the other options file (described at the link). I think you can put the password in there and then chmod 600 it.

Comment on Re: Secure ways to use DBI?

Replies are listed 'Best First'.
(jeffa) 2Re: Secure ways to use DBI? by jeffa (Bishop) on Apr 17, 2003 at 02:54 UTC
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)	[reply] [d/l]

Replies are listed 'Best First'.

(jeffa) 2Re: Secure ways to use DBI?
by jeffa (Bishop) on Apr 17, 2003 at 02:54 UTC

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

gmax

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)

[reply]
[d/l]