Can someone plz tell me how to set DB proxy for the below case.
- Three machines in same network - 172.16.1.10, 172.16.1.11 and 172.16.1.12
- 172.16.1.12 have mysql instance running on 3306 port
Users from 172.16.1.10 machine want to connect to above mysql instance by using 172.16.1.11 machine and one port number(say 9999) as pass-through.
$> mysql -h 172.16.1.11 -P 9999 -u user1 -p pwd1'
what all iptables rules need to be created to achieve this?