[mythtv-users] Cannot Connect To Backend

[Paul Harrison]

On 29 November 2014 at 00:02, Hika van den Hoven <hikavdh at gmail.com> wrote:
> Hoi Hika,
>
> Saturday, November 29, 2014, 12:09:46 AM, you wrote:
>
>> Also check what you have for Host in ~/.mythtv/config.xml on your backend.
>> If it's 127.0.0.1, change it to localhost.
>
> This is funny. I have my ip-number in my.cnf and still localhost works
> but 127.0.0.1 not. I never noticed for I never type the numbers.
> Obviously localhost is either not resolved or is resolved to the full
> ip-number. Weird.
>
> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com
>

If you use 127.0.0.1 the client will always use the network to connect
to the Mysql server even though they  are both on the same machine. If
you use localhost the client will try to connect through a socket to
the server bypassing the network altogether. There is a Mysql setting
to disable the networking altogether skip-networking which mean only
local clients can connect through the socket.

I'm not a sysadm but I was once told that using bind-address = 0.0.0.0
was bad practice and for added security you should use the actual
address you want Mysql to listen on here.

Paul H.