Connecting local exe to web-based mySQL Server

Posted on 2010-01-04
Last Modified: 2013-11-23
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. 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.
Question by:WeeStinker
    LVL 16

    Accepted Solution

    Hi WeeStinker,

    You said :
    "Ideally I want something which I can send a query to and which will send me back a result set. Securely."

    If i understand you correctly you need something like AnyDac.
    You can drop the component to the form write the query and then connect to the remote database. AnyDac can securely send and receive queries.

    AnyDAC v 2.0 Core Features

    -Native access to SQL Server, Oracle, DB2, InterBase, MySQL and more.
    -Generic access to any database supported through Borland DBX and ODBC data sources.
    -Unified API for access to cross-database features.
    -First-class support for many database-specific features.
    -Unique ADO.NET-like data engine for Win32.
    -Optimized for best possible performance.
    -Advanced Data Access Options.
    -Full support for international applications, including full Unicode support in Delphi 2009 and later.
    -Cross-platform support though Free Pascal (FPC).
    -Perfect integration as back-end driver for RemObjects Data Abstract" for Delphi.
    -Linux support.
    -Full Unicode support.
    -SQL script engine.
    -Automatic connection recovery, connection sharing between application modules.

    Hope this helps.

    Author Closing Comment

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

    LVL 16

    Expert Comment

    I'm glad i could help :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now