From: Peter Brawley
Date: January 14 2005 2:06pm
Subject: Re: MySQL & Perl
List-Archive: http://lists.mysql.com/mysql/178484
Message-Id: <41E7D1FF.70700@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Gerald,

Your connect string needs to be DBI:mysql:<dbname>:<hostvar>.

PB

-----


Gerald Preston wrote:

>I am trying to get Perl to talk to MySQL that I have setup.  According to
>"WinMySQLAdmin1.4"
>
> 
>
>Local Host Name = GJW
>
> 
>
>Local User name = Jerry
>
> 
>
>Databases:
>
> 
>
>GJW
>
>   Club
>
>      bar
>
>   mysql
>
>   test
>
> 
>
>I am using the following code:
>
> 
>
>#!/perl
>
>use warnings;
>
>use strict;
>
>use DBI;
>
> 
>
>  my $dbh=DBI->connect( 'DBI:mysql:GJW:club:bar', 'gjw', 'password' ) or die
>"Cannot connect -> gjw!!<br>$DBI::errstr";
>
> 
>
>What am I missing?
>
> 
>
>Thanks,
>
> 
>
>Jerry
>
>
>  
>