I am totally lost here and I know this is a no brinier. I do not know what
I am doing wrong:
I can access from the command line by "mysql -u gjw -p" then "use club" and
I can do anything I want.
I am trying to access by Perl:
# line 6 following
my $dbh=DBI->connect( 'DBI:mysql:gjw:club', 'gjw', 'password' ) or die
I get the following error: "DBI connect<'gjw:club','gjw'...> failed: Unknown
MySQL server Host 'club' <11001> at line 6";
How do I find out my server HOST name is? What else is wrong?
I have done this many times working with Oracle and never had this problem!
From: Gerald Preston [mailto:jwp@stripped]
Sent: Friday, January 14, 2005 12:56 AM
Subject: MySQL & Perl
I am trying to get Perl to talk to MySQL that I have setup. According to
Local Host Name = GJW
Local User name = Jerry
I am using the following code:
my $dbh=DBI->connect( 'DBI:mysql:GJW:club:bar', 'gjw', 'password' ) or die
"Cannot connect -> gjw!!<br>$DBI::errstr";
What am I missing?