Can't connect to local host MySQL database

"Vance E. Neff" <[email protected]> Sat, 28 Mar 2009 10:18:49 -0400
Newsgroups gmane.comp.db.mysql.perl
Organization Vance's Consulting Co.
Message-ID <[email protected]>
Hello,

I'm having trouble connecting to my MySQL database on a Windows XP SP2 
system via Perl.

use DBI;
use DBD::mysql;

Can't connect to MySQL server on 'localhost' (10061) at ... this statement:
our $dbh = 
DBI->connect("dbi:mysql:database=test;host=localhost;port=3306","root","") 
|| die "could not open CNCJobs.MySQL database! $DBI::errstr";

Note that the above line probably wrapped.

Version info:
perl version v5.10.0 built for MSWin32-x86-mulit-thread by ActiveState
MySQL Server version: 5.1.32-community
DBI::VERSION = 1.607
DBD::mysql::VERSION = 4.005

I am able to use the MySQL Command line statement:
mysql -u root -h localhost test.
and can successfully use a select query on the database.

Any ideas?

Vance


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]