[Gllug] MySql question - to which I know the answer, honest guv
andy at mac1systems.com
andy at mac1systems.com
Thu Jan 5 18:17:28 UTC 2006
> I've just installed MySql 4.1 on a new Sarge system and the mysql
> daemon process is listening only for local connections:
>
> mythtv at emperor:~$ netstat -ln | grep 3306
> tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
>
> Now I've done this many times before and I know exactly how to fix it,
> but...
>
> ...I've forgotten. Nor can I find it in any of the accompanying
> documentation.
>
> Would someone jog my increasingly unreliable memory and tell me how do
> I tell MySql to listen on *:3306 and not just 127.0.0.1:3306?
>
Have a look in your /etc/my.cnf (or my.ini)
Mine just has
master-port = 3306
I can't see where you'd limit it to localhost.
I had a problem previously where UML stopped external connections on FC4.
Andy
--
Gllug mailing list - Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug
More information about the GLLUG
mailing list