I provisioned this MySQL droplet: https://marketplace.digitalocean.com/apps/mysql
I am able to administer MySQL if I SSH via terminal, or if I go to
But I need to connect to my DB remotely. Whether I try to connect via terminal, or something like Sequel PRO, the connection fails with this error:
Host 'xxx.xxx.xxx' is not allowed to connect to this MySQL server
I followed every step of this guide (including setting bind-address to 0.0.0.0), but nothing changes and I’m still unable to connect: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
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.