From: Jeremy
Date: April 24 1999 1:38pm
Subject: Re: Getting "Can't connect to local MySQL server (21)" error from 
 perl script
List-Archive: http://lists.mysql.com/mysql/2331
Message-Id: <Pine.LNX.4.10.9904241334290.353-100000@thanatos>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Fri, 23 Apr 1999, Bill Rhodes wrote:

> I have a small problem connecting to a mysql database using perl scripts 
> and the DBI module.  When I try to issue a DBI->connect() from within the 
> script, I get an error (it's below).  I think the problem is that my mysql 

>    $dsn = "DBI:mysql:$database";
> 
>    $dbh = DBI->connect ($dsn,$user,$pass,'');

I wrote a script a few days ago for basically the same purpose
as you.  I just compared it to the lines above, and there is a
small difference.  Here's what I have:

$dsn = "DBI:$driver:database=$database";

$dbh = DBI->connect($dsn, $user, $password);

In the first line, $driver = "mysql" and $database =
the database name, and I think you can figure out
the second line.  I'm new to this MySQL/DBI/CGI stuff
too, so I'm not sure if it makes any difference.  You
might try putting in the "database=" part and see if
that works.

HTH,
Jeremy
-------------------------------------------------------
To automatically retrieve my PGP key via e-mail, send a
blank message with the subject line "fetch pgp key".