Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


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

Posted on 2003-11-28
Medium Priority
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 200 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
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: …
Suggested Courses

647 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