Solved

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

Posted on 2003-11-28
6
247 Views
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
0
Comment
Question by:mumuska
  • 2
6 Comments
 
LVL 5

Accepted Solution

by:
DeerBear earned 50 total points
Comment Utility
Hi,

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.

HTH,

Andrew
0
 

Expert Comment

by:progdelphi
Comment Utility
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...
0
 

Author Comment

by:mumuska
Comment Utility
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 ???
0
 
LVL 5

Expert Comment

by:DeerBear
Comment Utility
Hi,

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

HTH,

Andrew
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
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…

728 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

10 Experts available now in Live!

Get 1:1 Help Now