All geek questions in one place

MySQL Workbench not connecting via SSH

I installed the server using Laravel Forge. Authentication is done through the SSH keys that I provided.

I can connect to the server via putty using my private key. Also I can connect to mysql using mysql password.

But when I try to do the same in the Mysql Workbench, I get the following:

enter image description here

My keys are in .ppk format. The keys do not have a password.

I have no idea what to do. Please, help.

+5
source share
4 answers

I don't know if this applies here, but if you are using an older version of MySQL Workbench, try the latest version (currently 6.2). For an SSH connection: you need a key like OpenSSH, not putty (ppk). However, you can use putty to convert to OpenSSH format.

+11
source

The problem is that "MYSQL Hostname" should be "localhost" or "127.0.0.1".

+1
source

The MySQL hostname must refer to the SSH server. If your MySQL server is located on the same machine as the SSH server, try using "localhost" instead of your SSH IP server.

0
source

For me, the default package in Ubuntu 18.04 using "apt install mysql-workbench" installs v6.3.8, which has an error with the ssl / tunnel connection (along with 6.3.9) ... I uninstalled / uninstalled and installed the latest version of deb from https://dev.mysql.com/downloads

0
source

Source: https://habr.com/ru/post/1204366/

More articles:


All Articles