in reply to Remote connection to mysql

Hi, I haven't seen that syntax before to connect to dbi before (the 'dbi:mysql:tickets@webhost.mydomain.org:3306' part), I normally use something like: 
$dsn="DBI:mysql:database=$database;host=$hostname;port=$port";
$dbh=DBI->connect($dsn, $user, $password);

[download]
(taken straight from the DBD::mysql manpage)

Replies are listed 'Best First'.
Re^2: Remote connection to mysql
by mhearse (Chaplain) on Apr 23, 2005 at 19:36 UTC
    Thanks for your reply. That works perfectly. I was using the syntax from the DBI man page. I guess the DBD::mysql requires a different syntax. Lesson learned.
[reply]
[reply]

In Section Seekers of Perl Wisdom