Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Cannot Connect To Private Network MySQL
2 droplets same data center, same project.
Both droplets are behind the same firewall.
I am attempt to connect from Droplet 1 to MySQL on Droplet 2
however, I keep getting:
“ERROR 2003 (HY000): Can’t connect to MySQL server on”
telnet xx.xxx.xx.xx 3306
telnet: Unable to connect to remote host: Connection refused
Telnet over port 22, 80, 443 is all fine.
I can ping ok.
I have set my mysql.cnf file to bind over 0.0.0.0
I have set up a user with the @ % for the sake of debugging the connection issue, but still no luck.
I restarted mysql
I flushed the privileges.
netstat -tulnp | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 23317/mysqld
What am I missing 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.×