delphi connecting to mysql server (in internet mysql server) and giving query

Posted on 2003-11-28
Last Modified: 2010-04-05
how to create (please, give example)  delphi programm whitch can connect to mysql server in internet and do some query (select, input, update...) and take result
Question by:mumuska
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

DeerBear earned 50 total points
ID: 9849583

It is *extremely* dangerous to expose your DB server on the
Internet. Please modify your working policy, otherwise you may get
yourself in HUGE troubles with hackers.

As to the question, the simplest and safest way I see to solve the
issue is to make a server app which will listen on a port and when
receives the SQL query executes it and then sends back the results.



Expert Comment

ID: 9850145
can you give me advice how create this application client->server with db safe ???
what db system I must use ???  what component ? (i prefer sql) , but i don't know about delphi data dase system...

Author Comment

ID: 9850569
why it is dangerous ???
i will use special login name and password which have restrikted access to mysql, to read some tables and input in others ? why it is not safe ???

Expert Comment

ID: 9851339

Because hackers know *lots* of ways to exploit a site or a DB server, gaining root privileges and so on.



Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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