Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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  -
share|improve this question

2 Answers 2

up vote 13 down vote accepted

The problem was that the server was listening internally only.

Removing the line bind-address 127.0.0.1 from /etc/mysql/my.cnf solved the issue.

share|improve this answer
    
This worked for me. Note the correct filename is /etc/mysql/my.cnf, not /etc/mysql/my.conf. –  Larry Battle Oct 6 '13 at 2:03
    
I changed my bind-address to match the server's external ip address and that worked for me. –  Buttle Butkus Jul 28 at 0:38

My suggestion, if you are sure that the ports are closed (I find it weird for a VPS to have that port closed) is to change the configuration file of MySQL to use another.

Simply open the configuration file in the terminal, sudo nano /etc/mysql/mysql.conf, and look for the [mysqld] section. In it, look for the line that reads port = 3306. Change it to another port not used and save the file.

Then simply either restart the VPS or restart the service, like sudo service mysql restart.

Just to note that, if the file mysql.conf is not in the one I mentioned above it can be in this other places:

/etc/my.conf
/etc/my.cnf
/etc/mysql/my.conf

And if the service command does not work, then do this:

sudo /etc/init.d/mysql restart

If the problem persists then in my case I would check iptables (I would actually delete everything in iptables just to start fresh if this could be an option) or any other firewall-enabled option.

Since they are VPS, I would also check the VPS Control Panel to see if it has any option that can block ports.

Apart from that, I would run nmap on the VPS to see what ports you have opened. You need to run it from outside the VPS to see what ports they have opened.

netstat -tuplen is also a good idea to see what opened ports you have on the server and which ones are in LISTEN mode.

share|improve this answer
    
Hey, I tried it on another port and its still miss behaving, I also tried 'iptables -A INPUT -i eth0 -p tcp -m tcp --dport PORT -j ACCEPT' but no luck :( .. edit im not o eth0 .. might stil have hope. –  Andy Mar 25 '13 at 2:27
    
@Andy Updated answer to include some more suggestions. –  Luis Alvarado Mar 25 '13 at 2:34
    
Thank you for the suggestions Luis I will look into this. –  Andy Mar 25 '13 at 2:41
    
I have updated the results of netstat -tuple to the question. Looks like there is an issue here. –  Andy Mar 25 '13 at 22:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.