Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DirectMySQL

Status
Not open for further replies.
Regany

Regany

Programmer
Aug 27, 2004
72
0
0
LV
the probelm is that using DirectMySQL for Delphi i can connect to to mysql server only from local computer, when i try to connect from lan or internet, there is an error.

maybe someone can advice some solution or other component to acces MySQL data base?
 
Sort by date Sort by votes
Are you hosting the MySQL database on a Linux server of Windows server?

Is there any firewalls in the way?

What does your connection string look like?




------------------------------------
There's no place like 127.0.0.1
------------------------------------
 
Upvote 0 Downvote
its WindowsXP pro SP2, firewall is off

its looks like that:

MySQLClient:= TMySQLClient.Create;
MySQLClient.Host := 'xxxxxx';
MySQLClient.user := 'xxxxxx';
MySQLClient.password := 'xxxxxx';
MySQLClient.Db :='xxxxxx';
MySQLClient.Port:='xxxxxx';
 
Upvote 0 Downvote
Do you have MySQL server running on the server? Can you actually run queries on the server?
Try downloading MySQL control center and see if you are able to connect. Also, make sure the port is 3306 (unless you have specified to connect through a different port).

I have been using DirectMySQL for a couple of years with no hassles, so I think it is something to do with the server set up.




------------------------------------
There's no place like 127.0.0.1
------------------------------------
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top