First, check your my.cnf file to see if you have a 'bind-address' entry. Such an entry will constrain you system only responding to machines on the same network. Failing that, have you checked you firewall settings? Are you sure that can can even reach port 3306 on that machine from the outside world? You might try setting up a packet sniffer like Ethereal on the server to listen for connections to port 3306 and then try to connect from the outside. If you see no connection attempt being made, then very like your network configuration is not allowing these connections through to the server.
- michael dykman On Fri, 2005-02-04 at 12:48, [EMAIL PROTECTED] wrote: > Hi I've a question I have a delphi program that connects to a mysql > database via obdc, and works perfect in the lan and in the server, I want > to know if I can enter the database if I have the program installed in > another city or place, I know that I have to enter the IP of the server > but I've tried this and it doesnÂt work when I try to connect to mysql > from outside de lan I receive the message > > error 2003: canÂt connect to xxx.xxxx.xxx.xxx (10061) > > I create a host in the user database of mysql with % > > > > Host > User > Password > Select_priv > Insert_priv > Update_priv > Delete_priv > Create_priv > Drop_priv > Reload_priv > Shutdown_priv > Process_priv > File_priv > Grant_priv > References_priv > Index_priv > Alter_priv > > > > localhost > root > > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > > > > % > root > > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > > > > localhost > > > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > > > > % > > > N > N > N > N > N > N > N > N > N > N > N > N > N > N > > > > 200.87.51.XX > prueba > 1f3d25cd5ea79fae > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > Y > > Revisar todos/as / Desmarcar todos Con marca: > > And i canÂt connect to mysql . > > Is there something more that I have to do in order to work? > > Regards > > Marcelo -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
