[Gllug] MySql question - to which I know the answer, honest guv

[Benedikt Heinen]

>> 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


change bind-address to 0.0.0.0, that should help

bind-address            = 0.0.0.0



Benedikt

--
                     Gaudeo te illud de me rogavisse.
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug