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
