A chronological documentation test project, nothing serious, really!

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*
LISTEN     1768/mysqld

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

#bind-address           =

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

#netstat -l
tcp        0      0  *
LISTEN     14134/mysqld

Tags: , , ,

Posted by

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

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

Tags: , , ,

Posted by