[Gllug] MySQL & ISPConfig

Andy McGarty andy at mac1systems.com
Wed Jul 25 14:53:46 UTC 2007


> "We want MySQL to listen on all interfaces, not just localhost,  
> therefore we edit
> /etc/mysql/my.cnf and comment out the line
>
>      bind-address = 127.0.0.1:"
>
> however my /etc/mysql/my.cnf doesn't include this line and apart from  
> comments the only
> lines it contains are:
>
>      [client]
>      port     = 3306
>      socket   = /var/run/mysqld/mysqld.sock
>
> In the output of netstat -tap you should see a line like this:
>
>      tcp 0 0 *:mysql *:*  LISTEN  4997/mysqld
>
> In fact the only reference to mysql is:
>
>      tcp 0 0 localhost.localdo:mysql *:* LISTEN 3604/mysqld
>
> Can someone give me clue on how to fix MySQL so it will listen on all  
> interfaces
If it needs to listen on port 4997 (which isn't the normal port) then  
change this line
       port     = 3604
to
       port     = 4997

But anything else running on the machine that uses mysql won't work.

Why do they want it to listen on all interfaces, is it a remote box.  Have  
you tried it with the standard config, it might "just work"?

Andy
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug




More information about the GLLUG mailing list