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

Posted May 21, 2016 17.4k 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?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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.