CODEWITHSUNDEEP
mysql-workbenchssh-keys
Óscar del Olmo
Óscar del Olmo

Reputation: 41

MySQL Workbench failing to connect via SSH due to key

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.

Upvotes: 4

Views: 16477

Answers (2)

Franck Dernoncourt
Franck Dernoncourt

Reputation: 83387

The bug was reported here for MySQL Workbench 6.3.8, 6.3.9 on Microsoft Windows: https://bugs.mysql.com/bug.php?id=83485 (you can subscribe for email updates).

Upvotes: 1

Hugo14453
Hugo14453

Reputation: 101

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

Upvotes: 10

Related Questions