Trying to create a remote management connection to the MySQL server via MySQL Workbench v6.3.5 gets me an "ERROR Could not establish SSH connection: ('Bad authentication type', [u'publickey']) (allowed_types=[u'publickey'])." error message.
I've already tried the workarounds published on this older post, and this one as well but can't get it to work.
The SSH key works fine to establish a command-line connection via OpenSSH on terminal, but Workbench is unable to accept it.
解决方案
Ok, I have a solution that worked for me.
You cannot password protect the key.
It must be exported in Open SSH format.
Generate a new public key without a password and add it to your server. Then export it in openssh format and use that in MySQL workbench.
Let me know