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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
