?
Solved

Connecting local exe to web-based mySQL Server

Posted on 2010-01-04
3
Medium Priority
?
405 Views
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. 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.
0
Comment
Question by:WeeStinker
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
CodedK earned 2000 total points
ID: 26178323
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.
0
 

Author Closing Comment

by:WeeStinker
ID: 31672480
Looks perfect, thanks. I'll get the trial later today and put it through its paces.

Thanks
WS
0
 
LVL 16

Expert Comment

by:CodedK
ID: 26178771
I'm glad i could help :)
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

807 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