MySQL Workbench not connecting over SSH

Question

I installed a server using Laravel Forge. Authentication is via SSH keys which I provided.

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

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

My keys are in .ppk format. The keys don't have a password.

I have no idea what to do. Please assist.

Answer 1

I don't know if that applies here, but if you use an older version of MySQL Workbench try the latest one (currently 6.2). For the SSH connection: you need an OpenSSH type key, not putty (ppk). You can use putty to convert to OpenSSH format, however.

Answer 2

I would like to complement Mike's answer, and include the step-by-step for those who don't know the use of Putty to perform the conversion that Mike refers to.

Open the PuTTYgen program > Conversions > Import Key > 'Select your key with the .ppk format' > Export OpenSSH> Select the directory and save the new format.

Use this file into mysql worckbench and it will work.