Binding to a specific ip address when using the PHP mysql_connect function

Question

I have a Cent OS setup running a pretty standard LAMP stack and I have two publicly available IP addresses (eth0 and eth0:1).

I want to use the second IP address (eth0:1) when connecting out to a remotely hosted MySQL database. How can I go about that?

Thanks!

Answer 1

If you have root access, you can do SNAT with iptables to use a specific source IP for this particular destination:

iptables -t nat -A POSTROUTING -o eth0 -d <mysql_server_ip> -j SNAT --to-source <source_ip>