MySQL Bugs: #54990: Workbench for Mac OSX will not connect to Server on LAN.

Bug #54990	Workbench for Mac OSX will not connect to Server on LAN.
Submitted:	4 Jul 2010 19:45	Modified:	8 Aug 2010 4:55
Reporter:	Rick Martin	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.25	OS:	MacOS (10.6.4)
Assigned to:		CPU Architecture:	Any

Description:
-MacBook Pro, dual install with Mac OSX 10.6.4, Windows 7 
   MySQL Workstation 5.2.25 installed on both OS's 
-MySQL Community Server 5.1.48, on Windows Home Server, SP2. 
-Port 3306 opened on the router, and forwarded to the server. 
-Two users on the MySQL server, root and mager, both passworded, host set to '%' 

Error message attempting to connect:

Failed to Connect to MySQL at 192.168.0.195:3306 with user root 
Can't connect to MySQL server on '192.168.0.195' (4) 

On local lan, in OSX with Mac attached to the wireless network, I get the error message above. If I boot into Windows 7 I can connect fine. If I boot my Boot Camp partition up in VMWare, it connects fine. If I have my Mac at work and I connect in OSX, I can connect just fine. It's only a problem with the system on a local LAN. 

How to repeat:
Install workstation on a Mac system, attempt to connect to the Workbench to a server on a local lan. 

Suggested fix:
Unknown, depends on the meaning of error code 4. May be dependent on the wireless connection, but I used two separate wireless networks to connect, and it will connect fine from another subnet (at work)

Can you connect to the same server from Mac successfully with mysql command line client? Please, send also the results of:

select host, user from mysql.user;

from the server.

Hi there,
I just want to confirm the same issue in my system. In my case we have the server on Ubuntu and I am unable to connect from Workbench for Mac OSX from the local wireless network at my office or from VPN. But if I switch to my bootcamp partition running Windows 7, I can connect to the server without any issues. Looking forward for a solution. Thx.

David,

Then, please, provide the same information for your case I've asked about in my previous comment.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".