Navicat and remote MySQL connection problems
Having a rough time trying to connect to my droplet’s MySQL server through an external software called Navicat. here’s what I’ve done so far;
• adjusted my.cnf to be bound to 0.0.0.0 and checked through netstat that 0.0.0.0:3306 is listening
• followed this tutorial to open up 3306 - https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-iptables-on-ubuntu-14-04
Still, when trying to connect, I get the following error (delivered very fast);
“CONNECTION FAILED - Server unexpectedly closed network connection”
I’m trying to use SSH credentials with my root MySQL username & password on the IP 188.8.131.52 and port 3306.
Can you point me in the right direction here?