04 Sep 2007 MySQL Not Listening On A Public IP

By default, MySQL (on Debian) doesn’t listen on the public interface:

#netstat -l
tcp        0      0 127.0.0.1:3306          0.0.0.0:*
LISTEN     1768/mysqld

In /etc/mysql/my.cnf, comment out the bind line:

#bind-address           = 127.0.0.1

And restart MySQL. Then it will listen on the public interface, and you should be able to connect.

#netstat -l
tcp        0      0 0.0.0.0:3306            0.0.0.0:*
LISTEN     14134/mysqld

Filed in Linux with 0 Comments

01 Feb 2007 Utskrift av port, pid og daemon navn v.h.a netstat

netstat -nap| egrep "(0.0.0.0).*(0.0.0.0).*LISTEN" | gawk '{print $4 ":" $7}' | egrep -o ":(.*)" | cut -c 2-|sed 's/\//\:/'