Bug #23149 mysqld bind-address only allows binding to one IP address
Submitted: 10 Oct 2006 19:42 Modified: 11 Oct 2006 13:09
Reporter: Thomas Vander Stichele Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[10 Oct 2006 19:42] Thomas Vander Stichele 
Description:
bind-address only allows specifying one IP address. In an environment like ours, where a machine has more than one physical NIC, each with a few virtual NIC's for different services, it is not possible to for example bind to two virtual IP's to serve both NIC's.

It's been suggested to listen to all and lock down in a firewall, but this doesn't work in all situations, and is messy when you are trying to secure your system and  make sure that mysql listens to no more interfaces than necessary.  Also, connections on localhost bypass the firewall completely, so running monitoring software to make sure MySQL is not accessible through ports it shouldn't be accessible on breaks.

How to repeat:
specify bind-address as a comma-separated list of ip addresses

Suggested fix:
have bind-address take a comma-separated list of ip addresses to bind to
[11 Oct 2006 13:09] Valeriy Kravchuk 
Duplicate of a well-known feature request, bug #14979 (read bug #20571 also).