From owner-freebsd-hackers@FreeBSD.ORG  Mon Feb 21 09:01:30 2005
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
Delivered-To: freebsd-hackers@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2931316A4CE
	for <Freebsd-hackers@freebsd.org>;
	Mon, 21 Feb 2005 09:01:30 +0000 (GMT)
Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E4A8F43D4C
	for <Freebsd-hackers@freebsd.org>;
	Mon, 21 Feb 2005 09:01:29 +0000 (GMT)
	(envelope-from mhersant@comcast.net)
Received: from [192.168.2.102]
	(c-24-22-136-36.client.comcast.net[24.22.136.36])
	by comcast.net (rwcrmhc12) with ESMTP
	id <2005022109012901400hlac6e>; Mon, 21 Feb 2005 09:01:29 +0000
Message-ID: <4219A362.2050800@comcast.net>
Date: Mon, 21 Feb 2005 01:01:22 -0800
From: Matt <mhersant@comcast.net>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Freebsd-hackers@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: remote connection to mysql
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 21 Feb 2005 09:01:30 -0000

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