MySQL Workbench failing to connect via SSH due to key

Question

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.

Answer 1

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