How to allow mysql remote connections via particular interface

Question

I have a 10.237.49.251 IP on eth0 and another IP on another interface

How do I enable remote mysql calls on eth0 device?

Answer 1

The mysqld configuration file - at /etc/mysql/my.cnf on my Linux box - has a bind-address option. This can be set to a particular IP address, like 10.237.49.251, and MySQL will then only listen on that interface (eth0).

The default (at least on Ubuntu) is to listen only on localhost, aka. the loopback interface (127.0.0.1).

Otherwise, MySQL can listen on all available ports and interfaces, which can be explicitly specified with bind-address=0.0.0.0.

Answer 2

you can use :

iptables -A INPUT -p tcp --dport 3306 -d 10.237.49.251 -i eth0 -j ACCEPT