WeeStinker
asked on
Connecting local exe to web-based mySQL Server
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad i could help :)
ASKER
Thanks
WS