I have a VPS with MySQL 5.5, which is listening only on localhost because of obvious security reasons. I have set up VPN connection from my own machine to that VPS and I connect successfully.
What would be the best way to grant same access to all MySQL databases to anyone connected to the VPN as if it was a localhost request?
I might be asking this question in rather silly way, so if you don't get my idea, I will elaborate.
edit: The VPS is Linux (Cent OS 5.6), if that helps. MySQL is listening on 3306. I have currently forwarded all connections that come from my IP to port 3306 on the public address of the machine to 127.0.0.1:3306. But this is not very convenient, as I tend to travel and when I'm not at home, this method fails.