MySQL Bugs: #75745: mysql workbench can not connect "bad handshake"

Bug #75745	mysql workbench can not connect "bad handshake"
Submitted:	3 Feb 2015 12:17	Modified:	5 Mar 2015 23:21
Reporter:	Hilmi Erdem KEREN	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	6.2	OS:	Linux (Ubuntu 12.04 (elemos))
Assigned to:		CPU Architecture:	Any
Tags:	bad handshake

Description:
Trying to connect to a server which is connectible using bash interface.

However, when I try to connect with the same credentials from workbench, It says "bad handshake".

To see more info, I tried to connect from different UI windows and I found 

" error calling Python module function DbMySQLRE.connect" when I tried to connect with schema transfer wizard.

How to repeat:
Select Standart connection method.

Install 12.04 version of Ubuntu
Install mysql-client
Install Workbench.
Enter host, port, username and password.
Click connect.

Thank you for the bug report. Please provide the version of mysql-client and WorkBench versio 6.2.X. Thanks.

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".

I try to connect mysql 5.1.11 to workbench  8.0 but it saying bad handshake

testing connection to MySQL 5.6.22 from Workbench 8.0.12
"Bad handshake" message appears instantaneously.
connect_timeout is set to 10 seconds.

Just a note, MySQL Workbench is also giving me the "Bad Handshake" error.

I get it when using 8.0.12 build 13312926 CE on Arch Linux (with libmariadbclient 10.1.34-1) when connecting to a mysql instance 14.14 Distrib 5.1.73 on CentOS 6.5 (mysql-server-5.1.73-8.el6_8.x86_64).

The error is immediate.

I do NOT get it:

- using the mysql CLI to the same server as above from the same client machine (Arch Linux, mariadb-clients 10.1.34-1)

- when connecting to a more recent (compat) version, Ver 15.1 Distrib 10.1.32-MariaDB (mariadb101u-server-10.1.32-1.ius.centos7.x86_64 from the IUS repository on CentOS 7.5.1804)

- when using PyMySQL 0.9.2

Will include outout of --log-to-stderr and an strace shortly.

Appreciate your status update on this; it's affecting multiple people.

mysql-workbench --log-to-stderr output (scrubbed)

Attachment: stderr.log (text/x-log), 2.93 KiB.

stack trace (scrubbed)

Attachment: strace.out (application/octet-stream, text), 22.07 KiB.

cross-referencing: bug #91943

Remove MysqlWorkbench and install MysqlWorkbench 6.1.7

fixed by uninstalling 8.0.12 and installing 6.3.10