Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 21 Feb 2005 01:01:22 -0800
From:      Matt <mhersant@comcast.net>
To:        Freebsd-hackers@freebsd.org
Subject:   remote connection to mysql
Message-ID:  <4219A362.2050800@comcast.net>

next in thread | raw e-mail | index | archive | help
Hi,

I'm trying to connect remotely to my database server.  It is MySQL 4.1.7 
which I install from ports.  I created a user with permissions to 
connect from any remote location.  I'm using Perl DBI, like this:

use DBI;

my $dbh = DBI->connect(
      'dbi:mysql:database@host.org:3306',
       'user', 'passwd', {
       RaiseError => 1, AutoCommit => 1
   }
);

Yet I continue to receive connection errors.  Can't connect to the MySQL 
server on 3306 (10061).  I'v verified that the server is listening on 
the port.  I also found some info on google about Perl DBD::mysql 
problems.  I tried resetting the user's password with the OLD_PASSWORD 
option.  Nothing works.  Can anyone help???



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4219A362.2050800>