MySQL Workbench with Debian Jessie - TCP/IP over SSH does not work

According to https://bugs.mysql.com/bug.php?id=74658 the issue presents itself when using openssh 6.7 the python libraries shipped with MySql workbench. While adding the "KexAlgorithms" to the sshd config works, you can update the python libraries that come with MySql Workbench. This may be handy if you don't have control over the sshd config...

If you scroll down in the bug report, there are instructions to download and copy the paramiko and ecdsa libraries.


I have found the solution.

I added this line to my /etc/ssh/sshd_config file:

KexAlgorithms [email protected],ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1

and restarted ssh: systemctl restart ssh

as suggested by this post: https://stackoverflow.com/questions/26577494/aptana-sftp-key-exchange