Link to home
Start Free TrialLog in
Avatar of WeeStinker
WeeStinkerFlag for United Kingdom of Great Britain and Northern Ireland

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.
ASKER CERTIFIED SOLUTION
Avatar of CodedK
CodedK
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WeeStinker

ASKER

Looks perfect, thanks. I'll get the trial later today and put it through its paces.

Thanks
WS
I'm glad i could help :)