Fw: MyODBC for XP connects Linux MySQL Server - Jorge Bastos - com.mysql.lists.win32

12 messages in com.mysql.lists.win32Fw: MyODBC for XP connects Linux MySQ...

From	Sent On	Attachments
Tata Respecia	05 Sep 2005 22:59
Bernard LEFEUVRE	06 Sep 2005 00:16
jbon...@sola.com.au	07 Sep 2005 15:43
Tata Respecia	07 Sep 2005 18:49
J.R. Bullington	07 Sep 2005 19:59
Daniel da Veiga	08 Sep 2005 06:46
Jorge Bastos	08 Sep 2005 07:36
SGr...@unimin.com	08 Sep 2005 07:48
Tata Respecia	08 Sep 2005 16:07
Tata Respecia	08 Sep 2005 16:14
J.R. Bullington	08 Sep 2005 18:13
Jorge Bastos	09 Sep 2005 01:10

Subject:	Fw: MyODBC for XP connects Linux MySQL Server
From:	Jorge Bastos (mysq...@decimal.pt)
Date:	09/09/2005 01:10:12 AM
List:	com.mysql.lists.win32

On the linux box try:

------- netstat -ln|grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

-------

if nothing apears, you should put the option in the my.cnf file: bind-address = 0.0.0.0 if mysql >= 4.1.x

jorge

I would advise to use:

telnet hostname 3306

That's the best way to try :-)

I may be wrong, but it seems that's not an ODBC problem, if you can't connect because of a permission problem, the server returns another error regarding user and host permission. Maybe a firewall blocking the connection. Try connecting using the console, or another application that has native (not ODBC) support for MySQL (like the administrator or query browser) using the same user and pass. Check the versions, if both the local and the remote mysqls are the same (password format problems).