DirectMySQL

[Regany]

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?

 

[AP81]

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
------------------------------------

 

[Regany]

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';

 

[AP81]

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
------------------------------------

 

[Regany]

ok, i will try.