remote connection to mysql

[Matt]

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