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 126.96.36.199 and port 3306.
Can you point me in the right direction here?
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.×