Socket server handling MySQL queries from clients and return the response to them

[Islorvat]

Hello, Why would someone use this technique instead of letting apps directly query the MySQL server? Are there any security benefits or what? Thanks, Adrian

[Richard Andrew x64]

It's dangerous to directly expose the database over the internet. It's much safer to use a proxy in between the clients and the database, because you can enforce authentication and data access security.

The difficult we do right away... ...the impossible takes slightly longer.

[SledgeHammer01]

You don't have to build a socket server... could do something much easier like WCF or a web service. Never expose your DB server to the internet. Do you want script kiddies connecting and doing DROP TABLEs :)? Any company with even a remotely real IT department will not allow this anyways. Standard IT security protocol.