[Gllug] MySQL & ISPConfig

Peter Ball CFL at marguet-ball.net
Wed Jul 25 13:28:37 UTC 2007


I'm following the instructions in http://www.howtoforge.com/perfect_setup_ubuntu_6.06
to set up LAMP & ISPconfig on Ubuntu Server 6.06.01
and have run into a blockage.

"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

Thanks

-----------------------------------
Peter Ball
Computers For Linguists
peter.ball at marguet-ball.net
Tel:    +44(0)20 7732 1741
Fax:    +44(0)20 7358 9214
Mobile: +44(0)77 1968 2913
45 Endwell Road, London, SE4 2PQ, United Kingdom

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




More information about the GLLUG mailing list