Cant connect sequel pro with database, but can access through terminal
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
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
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.×