Jim McAtee wrote: > Quick question or two regarding the IP addresses MySQL listens on: > Does MySQL automatically listen on all IP addresses bound to the > machine on which it runs? (MySQL 3.23.xx on Windows 2000). > I've got a multi-homed server with dual NICs. To date I've always > connected from other servers on an IP address bound to NIC #1. I'd > like to change this to use an IP address bound to NIC #2, on a > different subnet. Will this require any configuration changes to the > MySQL server? It's been quite a while since I first configured the > server. I am using 'bind-address=127.0.0.1' in my.ini to prohibit all external contacts -but via the local webserver ;-)-. So, I see no reason for you to change your config, unless the service is started with the option '--bind-address=IP-NIC#1' or has 'bind-address=IP-NIC#1' in its my.ini.
HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]