bind (listen) question

2005-09-21 Thread Andrea
Hi All, I have a linux box with 2 ethenet interfaces let's say one public 10.10.10.10 and one private 192.168.1.1. How can I configure my.cfg to listen on 192.168.1.1 and 127.0.0.1 but not 10.10.10.10? Thanks in advance. Andrea Sodomaco -- MySQL General Mailing List For list archives:

Re: bind (listen) question

2005-09-21 Thread Alexey Polyakov
Theres --bind-address mysqld startup option, but I'm afraid it allows specifying only one IP to bind to. One of workarounds for your problem is to make it listening on all IPs, but configure firewall to drop all TCP packets going to port 3306 not on IPs you want. -- Alexey Polyakov -- MySQL