Can't connect to TCP or UDP ports

September 19, 2014 2.1k views

Hi guys, I just made a droplet where I'm running Apache and SQL servers rightly. But I'm trying to catch some information through the network ports, for this I'm trying sending packets with PacketSender or some cellphone apps... however I can't connect to the ports. I already used:

iptables -I INPUT -p tcp --dport #### --syn -j ACCEPT

or for UDP:

iptables -I INPUT -p udp --dport #### -j ACCEPT

But still is not working. Using nestat -a I expected to see a complete list of the listening or inactive ports just as in Windows, but it only lists the already-in-use ports...
I would appreciate a lot if you can answer me as soon as possible.

Have a nice day

1 comment
1 Answer

Hi criws93!
MySQL by default binds to the localhost port only. If you run the following command

netstat -an | grep 3306

You should see something like

This can be changed by modifying the config file for MySQL:

sudo nano /etc/my.cnf

You will want to change the IP at the word 'bind' to 'bind='

Note: This can cause security problems! Please be aware!

Now you can restart MySQL:

sudo service mysql restart

And then run the following command again:

netstat -an | grep 3306

And you should see something like

If you have any further questions, let me know!

-Cooper Thompson

Have another answer? Share your knowledge.