MySQL Forums :: Workbench - SQL Browser, Editor, Refactor :: Ubuntu MySQL Workbench can connect to database but all queries timeout with Error Code 1203: Lost Connection

Summary
I am having a very peculiar issue with MySQL Workbench on our work network. I am able to connect/query remote databases from command line but in MySQL Workbench I can only connect and queries timeout. I believe the issue has to do with the network/firewall but am looking for some help in diagnosing and troubleshooting it

Details:
Within this "work" network MySQL Workbench can connect to all remote databases. When I attempt to run a query that would return in milliseconds the query just spins/hangs until the connection is lost (error 1203). What is even more interesting about this is that in the same "work" network via command line I can connect to these same remote databases and query from them without issue. I can also connect to these same remote databases and successfully run queries from another third party MySQL client called "Emma"

From other networks like my "home" network I can connect to these remote databases and query from them without issue from both command line and MySQL Workbench

Based onthe information above it seems like this issue is specific to this network/firewall. I worked with our IT team and they turned off all firewall settings and even put me out in the DMZ but I still was having same issues. That seems like it should rule out firewall so maybe network issues?

Other things to note:
- To access the remote databases I am VPN'ing into the network first. I am connecting to VPN on all networks so this doesn't seem to be the issue
- These are normal tcp/ip connections to the remote databases
- Other people in the office that use MySQL Workbench on Mac and Windows are not experiencing this issue

Why would MySQL command line work and MySQL workbench not? Why would MySQL Workbench work fine on this network on other OSes? Are there any settings in MySQL workbench that I could alter to fix this? Any ideas of how to troubleshoot this?


Setup
OS: Ubuntu 12.10 64-bit
Workbench Version: 5.2.45
VPN: Cisco VPN service

Thanks in advance,

Simon



Edited 3 time(s). Last edit at 01/17/2013 12:47PM by Simon Engelbert.