Cant connect sequel pro with database, but can access through terminal

May 21, 2016 11.3k views

Hello all

I have created my first droplet and want to set up sequel pro to access my database as a GUI. I can access my database via terminal using the commands

ssh forge@my-droplet-ip-address

mysql -uforge -p

And then i can see my databases. However when going through sequel pro im getting the error:

Unable to connect to host MYIPADDRESS because access was denied.

Double-check your username and password and ensure that access from your current location is permitted.

MySQL said: Access denied for user ‘forge’@'localhost’ (using password: YES)

The details i have filled in on sequel pro are:

Username: forge

ssh user:forge
SSH KEY:~/.ssh/id_rsa

Any ideas?

1 Answer

By default MySQL does not listen on your public IP address. This can be changed in the /etc/mysql/my.cnf file on your droplet.

Commenting out or changing the line below to (all IPs) or your public IP address

bind-address     =

and then restarting with

service mysql restart

should correct this and allow your remote client to connect.

Have another answer? Share your knowledge.