PHWinfo - Afficher un message

01/05/2006, 23h16

dmcquay@gmail.com wrote:
> Hi,
>
> I am setting up MySQL on a development box. I have set it up and can
> connect from localhost, but I cannot connect from another computer on
> the network.

It's a typical config for the MySQL installer to enable
"bind-address=127.0.0.1" in the my.ini file. So only clients connecting
from the same host can use MySQL. Comment out that line to disable the
restriction.

This is a dev box, so I assume it's safe from attacks from the internet.
But in general, make sure that disabling the bind-address config
doesn't expose your MySQL instance to connection attempts from the
internet. You'll be hacked within a few minutes.

Regards,
Bill K.

01/05/2006, 23h16	#2
Bill Karwin Messages: n/a Hébergeur:	Re: Can't connect to mysql server dmcquay@gmail.com wrote: > Hi, > > I am setting up MySQL on a development box. I have set it up and can > connect from localhost, but I cannot connect from another computer on > the network. It's a typical config for the MySQL installer to enable "bind-address=127.0.0.1" in the my.ini file. So only clients connecting from the same host can use MySQL. Comment out that line to disable the restriction. This is a dev box, so I assume it's safe from attacks from the internet. But in general, make sure that disabling the bind-address config doesn't expose your MySQL instance to connection attempts from the internet. You'll be hacked within a few minutes. Regards, Bill K.