Hi! 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 "$DBI::errstr\n"; 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! Thanks, Jerry -----Original Message----- From: Gerald Preston [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 12:56 AM To: mysql@lists.mysql.com Subject: MySQL & Perl 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
