mysql type allowed_MySQL workbench SSH connection error [Bad authentication type(allowed_types=['pub...

可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):

问题:

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

回答1:

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.

回答2:

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

回答3:

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.