Can not connect to the MySQL database using Coda 2


I am hosting a website on a Raspberry Pi that has a MySQL server running.

Using Terminal on Mac, I can remotely ssh into the RPi and then connect to the server.

I am trying to remotely connect to the server using Coda 2, but it doesn't seem to be working. I chose the 'via SSH' option, using the following details:

(I've removed my login details)

However, using the exact same details with SequelPro, it works just fine?

What is going on here? Why is it not working for Coda?

This is a known issue with Coda 2. I'm going to assume you're using SSH keys, if not please elaborate.

Open ~/.ssh/config, you'll need to use sudo vim/nano/emacs because its a protected file. Then add these two lines:

IdentityFile /the/path/to/your/ssh/key

This asserts the identification of the SSH key.

Reference to the Coda docs: here