CODEWITHSUNDEEP
mysql-workbench
Rana Rashid
Rana Rashid

Reputation: 202

MySQL workbench SSH connection error [Bad authentication type(allowed_types=['publickey'])]

I have issue regarding SSH connection with my server. When i try to connect it results into error:"Bad authentication type(allowed_types=['publickey'])" Thanks

Upvotes: 5

Views: 8606

Answers (3)

test ing
test ing

Reputation: 31

FYI, my company uses a Yubikey and so the SSH part can be a bit mysterious. However, walking through a shell login with the yubikey yinit command, to ssh to IP (no password needed here), and finally to connecting mysql (still shell), I attempted to MySQL Workbench a few times with my different passwords to no avail.

Finally, I noticed the "SSH Key File" field and looked up where my .ssh file was -- /Users/myProfile/.ssh/ Set the "id_rsa.pub" file as it and voila!

Everything worked.

Upvotes: 0

Jeff
Jeff

Reputation: 383

You need to ensure that your private key is in openssh format. With puttygen you can export as Openssh. This worked for me.

Upvotes: 7

Shahid Mehmood Awan
Shahid Mehmood Awan

Reputation: 94

Check your username and public key this can cause problem. Attach the private key file with extension .ppk Also verify your connection with putty. Also check for the restriction on server.

Upvotes: 3

Related Questions