I have two VPS servers, and both have MySQL installed, one for testing and one for development. One of my servers won't let me connect from outside. With the user;
'mytestuser'@'%'
According to an open port finder, port 3306 for the offending server appears to be closed. I have C++ and Java programs of my own listening on arbitrary ports without any issues. Why is this happening and how can I fix it?
Ubuntu installed is Ubuntu 11.10 (GNU/Linux 2.6.32-042stab072.10 x86_64)
Results of netstat -tuple
on each server
Offending server
tcp 0 0 localhost.lo:submission *:* LISTEN root 39967664 -
Working server
tcp 0 0 *:mysql *:* LISTEN mysql 1847519288 -