List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 23 2005 1:49am
Subject:RE: MySQL & Perl
View as plain text  
At 13:28 -0800 1/22/05, Gerald Preston wrote:
>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";

For MySQL, the format for the DSN is:

DBI:mysql:db_name:host_name

Looks like you have a username (gjw) for db_name, and a database name (club)
for host_name?

Perhaps you want:

DBI:mysql:club:localhost

>
>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


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
MySQL & PerlGerald Preston14 Jan
  • Re: MySQL & PerlO'K Web Design14 Jan
  • Re: MySQL & PerlPeter Brawley14 Jan
  • RE: MySQL & PerlGerald Preston22 Jan
    • RE: MySQL & PerlPaul DuBois23 Jan