Cannot connect to MySQL via Sequel Pro
I am having trouble connecting to MySQL on my new Ubuntu 16.04 droplet via Sequel Pro.
I Installed MySQL via the DigitalOcean tutorial. I set a root password in
mysql_secure_installation, then restarted the service.
Checking for status shows the service is running.
My Sequel Pro configuration looks like this:
This exact configuration worked on previous droplets, but now I get:
MySQL said: Access denied for user 'root'@'localhost'
Note that I don’t have the usual
(using password: YES/NO).
All the solutions I found through Google don’t seem to help. They say to comment out
bind-adress 127.0.0.1 or set it to
bind-adress 0.0.0.0 in the MySQL config then restart, which I’ve done, but I still can’t connect.
What am I doing wrong? This is driving me mad…