Allow Remote Mysql Connections From One IP Address Only

Changes to MySQL Configuration

In my.cnf Comment out the binding for local address

#bind-address = 127.0.0.1

Restart the MySQL service:

/etc/init.d/mysqld restart

MySQL Login Credentials

Make sure user has % host permissions

Firewall Settings

Accept Connections from your trusted server. x.x.x.x being it’s ip address

iptables -A INPUT -p tcp --dport 3306 -s X.X.X.X -j ACCEPT

Drop connections from everybody else except local host

iptables -A INPUT -p tcp -i eth0 ! -s 127.0.0.1 --dport 3306 -j DROP