Solved

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

Posted on 2003-11-28
6
256 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

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…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

786 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