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]