connecting to remote computer with DBI

[Anon]

Hey folks,

I'm wondering how to connect to mysql on a remote machine with DBI and Perl. I tried the following, but it didn't work:

my $dbh = DBI->connect("DBI:mysql:test;<ip address>", 'username', 'password');

Any help here would be greatly appreciated!

Thanks,

Dave

[lawnmowerman]

Try:
my $dbh = DBI->connect( 'DBI:mysql:test;host=<ip address>', 'username', 'password' ) or die "Error connecting to db: " . DBI->errstr;

-Rich