由于密钥，MySQL Workbench无法通过SSH连接 [英] MySQL Workbench failing to connect via SSH due to key

问题描述

尝试通过MySQL Workbench v6.3.5创建与MySQL服务器的远程管理连接，使我收到错误无法建立SSH连接:('Bad authentication type'，[u'publickey'])(allowed_types = [u 'publickey'])."错误信息.

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.

SSH密钥可以很好地在终端上通过OpenSSH建立命令行连接，但是Workbench无法接受它.

The SSH key works fine to establish a command-line connection via OpenSSH on terminal, but Workbench is unable to accept it.

推荐答案

好的，我有一个对我有用的解决方案.

Ok, I have a solution that worked for me.

您不能用密码保护密钥.

You cannot password protect the key.

它必须以Open SSH格式导出.

It must be exported in Open SSH format.

生成一个没有密码的新公钥，并将其添加到您的服务器中.然后将其导出为openssh格式，并在MySQL工作台中使用它.

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.

让我知道

这篇关于由于密钥，MySQL Workbench无法通过SSH连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！