At 13:28 -0800 1/22/05, Gerald Preston wrote:
>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
For MySQL, the format for the DSN is:
Looks like you have a username (gjw) for db_name, and a database name (club)
Perhaps you want:
>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!
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com