DBD:mysql cannot connect

From: nickelstat (nickelstat_at_sbcglobal.net)
Date: 02/25/04 

Date: 25 Feb 2004 09:53:19 -0800

My first time trying mysql out. Very simple program
use DBI;
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
   which is "DBI:mysql:database=sunlighttravel;host=localhost;port=80"

$dbh = DBI->connect($dsn, $user, $password);
 --> stuck at connect(). All variables are verified set correctly.
$user="root";$password=""; Does that make a difference whether
password is NULl or blank?

While mysql client works correctly with the same parameters.

I'm on Win XP, Active Perl 5.8.3, DBI and DBD-mysql modules.
mysql 4.0.18-max-debug

The server log nevers sees a connection request via perl, only via
mysql client.

Where should I look?

tia

Relevant Pages

  • Re: Not exactly a dbi question
    ... Not exactly a dbi question [snip] ... I've been answering your question while assuming the mysql ... sure that would have bitten me had I been using JDBC or MySQL. ...
    (perl.dbi.users)
  • Re: Q: Problem figuring out versions of DBI
    ... > The reason why I'm trying to figure out my DBI version is so that I ... > version of MySQL that I have installed. ... To get the available drivers, ... You're trying to install DBD::mysql on a machine that does ...
    (comp.lang.perl.misc)
  • Re: MS SQL 2005 Express and MySQL on Windows
    ... needed to copy Mysql.rb from the DBI package to a new C:\Program Files ... DBI::InterfaceError: Unable to load driver 'Mysql' ... DBI::InterfaceError: Could not load driver (uninitialized constant ... Ruby to talk to a MySQL database on Windows. ...
    (comp.lang.ruby)
  • cPanel / DBI / mySQL / Exim issue
    ... I have recently come across a problem with cPanel/Fedora and DBI. ... Client does not support authentication protocol requested by server; ... I sent a ticket to cpanel, ... mysql: unknown variable 'old_passwords=1' ...
    (perl.dbi.users)
  • Re: getting DBI and ODBC to work with PERL and MYSQL data source
    ... and installed DBI and DBD::ODBC perl modules. ... experience issuing a SQL query through PERL to Mysql.. ...
    (comp.lang.perl.misc)