I've currently got mySQL open to the internet on my VPS. My local exe can access it simply using the server's static IP address.
That's great... but further reading (e.g. http://dev.mysql.com/doc/refman/5.0/en/security-guidelines.html
) tells me that unless I am extremely careful/lucky I could be in trouble especially if I scale up the number of users of the Exe file.
So, what do I need to put on the web server so that I can hide mySQL from the internet and only serve localhost queries through a web page or SOAP Service or ASP or what ?
Ideally I want something which I can send a query to and which will send me back a result set. Securely.