MySQL Server Forum - Is it possible to specify more than 1 interface at bind-address?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Is it possible to specify more than 1 interface at bind-address?

meulie@gmail.com

2005-06-10, 3:23 am

Hi all!

Is it possible to bind MySQL 4.1 to more than 1 interface? Will
multiple 'bind-address=x.x.x.x' statements do the job?

Regards,
Evert

Bill Karwin

2005-06-10, 3:23 am

meulie@gmail.com wrote:
> Is it possible to bind MySQL 4.1 to more than 1 interface? Will
> multiple 'bind-address=x.x.x.x' statements do the job?

This same question has come up from time to time on the newsgroup, and I
think we determined that the answer is no. The bind-address option
limits access to exactly one IP address.

If you need a more flexible configuration, do not use bind-address, but
instead use a firewall (e.g. ipchains if you use Linux) on your host
that runs MySQL server to specify which hosts can access MySQL's port
(3306).

Regards,
Bill

Sponsored Links