Solved

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

Posted on 2003-11-28
6
270 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
[X]
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
6 Comments
 
LVL 5

Accepted Solution

by:
DeerBear earned 50 total points
ID: 9849583
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
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...
0
 

Author Comment

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

Expert Comment

by:DeerBear
ID: 9851339
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

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

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…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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