From owner-freebsd-hackers@FreeBSD.ORG  Mon Feb 21 17:26:37 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 198FA16A4CE
	for <Freebsd-hackers@freebsd.org>;
	Mon, 21 Feb 2005 17:26:37 +0000 (GMT)
Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64])
	by mx1.FreeBSD.org (Postfix) with ESMTP id AD23843D31
	for <Freebsd-hackers@freebsd.org>;
	Mon, 21 Feb 2005 17:26:35 +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 (sccrmhc13) with ESMTP
	id <2005022117263301600sk1ihe>; Mon, 21 Feb 2005 17:26:33 +0000
Message-ID: <421A19C7.5080207@comcast.net>
Date: Mon, 21 Feb 2005 09:26:31 -0800
From: Matt <mhersant@comcast.net>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <4219A362.2050800@comcast.net>
	<20050221042738.T683@odysseus.silby.com>
In-Reply-To: <20050221042738.T683@odysseus.silby.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
cc: Freebsd-hackers@freebsd.org
Subject: Re: 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 17:26:37 -0000

Mike Silbersack wrote:

>
> On Mon, 21 Feb 2005, Matt wrote:
>
>> 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:
>
>
> Are you sure that you set up MySQL to accept TCP connections?  I think 
> it defaults to local sockets only; you can verify by running netstat 
> -na and seeing if there's anything listening on port 3306.
>
> Mike "Silby" Silbersack
>
Thanks for your reply.  I do see this in netstat output:

tcp4       0      0  192.168.2.23.3306      *.*                    LISTEN