virepoltd
By:
virepoltd

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

May 21, 2016 883 views
MySQL

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:

MYSQL host: MYIPADDRESS
Username: forge
Password: MY_PASSWORD
Database:forge

SSH host:MYIPADDRESS
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 0.0.0.0 (all IPs) or your public IP address

bind-address     = 127.0.0.1

and then restarting with

service mysql restart

should correct this and allow your remote client to connect.

Have another answer? Share your knowledge.