dban00b
asked on
MySQL Install on Windows won't accept remote host connections
Everything works great from the localhost, but remote connections get an error like "MySQL Connection is not allowed from host, YOURHOST"
Obviously I'm missing a config of some sort, this is a fresh install of 5.0.45 on Windows Server 2003 32-bit.
Thanks for any help with what I need to do/add/configure/etc
Obviously I'm missing a config of some sort, this is a fresh install of 5.0.45 on Windows Server 2003 32-bit.
Thanks for any help with what I need to do/add/configure/etc
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
My suggest stems from Linux, but I believe Windows might have something similar going on. Latest version of MySQL at least will by default bind itself to "localhost" (loopback interface) instead of "0.0.0.0" (all available interfaces) as a security measure. This setting can be changed from within my.cnf (my.ini, whatever:) with setting "bind-address" (which is under section "mysqld").