MySQL Bugs: #78948: Workbench 6.3.5 hangs on queries over SSH tunnel fix broke older ones

Bug #78948	Workbench 6.3.5 hangs on queries over SSH tunnel fix broke older ones
Submitted:	23 Oct 2015 18:13	Modified:	24 Oct 2015 2:41
Reporter:	Greg Thompson	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.3.5 build 201 CE (64-bits)	OS:	Windows (8.1)
Assigned to:		CPU Architecture:	Any
Tags:	SSH tunnel, workbench

Description:
After installing Workbench 6.3.5 to solve the "Workbench 6.2 hangs on basic queries over SSH tunnel bug" (Bug #74557) I was also experiencing, I found that the changes made in 6.3.5 breaks access via SSH tunnels to older versions of MySQL 5.1.47 which require the "Use the old authentication protocol" advanced option.  These SSH tunneled connections now receive a "Unsupported option provided to mysql_options()" error.  If I turn off the "Use the old authentication protocol" advanced option, I get "Malformed packet" errors.

I did not have the problem using Workbench 6.2.4 I was using previously.

- Greg

How to repeat:
Install Workbench 6.3.5 on Windows 8.1.  Attempt to connect to a legacy MySQL server requiring the old authentication protocol via a SSH tunnel, in our case a MySQL 5.1.47 server running on Media Temple.  You should get the error message in our case:

Cannot Connect to Database Server
Your connection attempt failed for user 'WebSpotOn-RO' from
your host to server at 205.186.157.48:3306:
'Unsupported option provided to mysql_options()'

Please:
...

Suggested fix:
My work around is to runn back to Workbench 6.2.4, but unfortunately this re-introduces the "Hangs on queries over SSH tunnel" bug #74557 to our newer version of MySQL 5.6.21-log running on AWS in RDS.

Thank you for the bug report. This report isn't related to same issue you reported: http://bugs.mysql.com/bug.php?id=78947 ? Thanks.

I didn't report 78947, however it does look like Adam Wortmann and I are encountering the same problem with 6.3.5.

Thank you for the feedback. Sorry I got confused anyway changing for duplicate please follow http://bugs.mysql.com/bug.php?id=78947.

I have the same problem - but running different OS:

OS: Ubuntu 16.04 + 14.04
MySQL Workbench versions with the same problem: 6.3.5, 6.3.6 ,6.3.7