MySQL Workbench (version 6.0.8) SSH Authentication Issue

mysql ssh mysql-workbench centos6
Hei picture Hei · Feb 3, 2014 · Viewed 26.1k times · Source

I am trying to connection to a MySQL server on Host X through machine Y over SSH.

The same setup (but older version of MySQL workbench) works on my another box (CentOS 6.3).

However, the same setup doesn't work on my CentOS 6.5.

I tried to use the SSH key for authentication between my box and machine Y over SSH, and it works when I ssh from my box to machine Y.

However, MySQL workbench gave me the following error: ERROR Could not establish SSH connection: Bad authentication type (allowed_types=['publickey', 'gssapi-with-mic']).

Some people suggested that I set AllowTcpForwarding to yes in /etc/ssh/sshd_config, which I did, restarted the service and rebooted my machine.

But I still got the same error.

Any idea?

It seems like for some reason the .ssh/id_dsa key isn't picked up when MySQL workbench attemtps to connect.

Thanks in advance.

Answer

user3938452 picture user3938452 · Aug 13, 2014

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

Related questions

How to connect MySQL Workbench to Amazon RDS?

I am accessing the Amazon RDS (MySQL) from Putty. MySQL Workbench works through SSH commandline only, but I would like to access the cloud MySQL host database directly from MySQL Workbench.

Read More
Connection to MySQL from .NET using SSH.NET Library

I am developing a web page (ASP.NET/ C#) that queries (MySQL) database on a remote server over SSH. I am using those two libraries (mysql-connector-net-6.9.7) and (Renci.SshNet.dll). I can access MySQL database using MySQL Workbench on the …

Read More
How to execute a MySQL command from a shell script?

How can I execute an SQL command through a shell script so that I can make it automated? I want to restore data I have collected in a SQL file using a shell script. I want to connect to a …

Read More