remote connection to mysql

Matt mhersant at comcast.net
Mon Feb 21 01:01:30 PST 2005


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 at 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???


More information about the freebsd-hackers mailing list