Geek Answers Handbook

MySQL Workbench WSH Connection Error [Invalid authentication type (allowed_types = ['publickey'])]

I have a problem with SSH connection to my server. When I try to connect, this results in the error: "Invalid authentication type (allowed_types = ['publickey'])" Thanks

+5
source share
3 answers

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

+3
source

You need to make sure your private key is in openssh format. With puttygen you can export as Openssh. It worked for me.

+6
source

FYI, my company uses Yubikey, and so part of SSH can be a little cryptic. However, walking through the shell logical interface using the yubikey yinit, ssh to IP command (no password is needed here), and finally, to connect mysql (still the shell), I tried several times to use MySQL Workbench with different passwords to no avail.

Finally, I noticed the "SSH Key File" field and looked at where my .ssh file is located - / Users / myProfile / .ssh / Install the file "id_rsa.pub" like hey presto!

Everything worked.

0
source

More articles:


All Articles