[mythtv-users] Issue with back end host address

[R. G. Newbury]

On 2021-06-15 12:55 p.m., Dave Ulrick wrote:
> When I turn on Listen on All IP Addresses, 192.168.4.7 is listed among 
> the set of IP addresses. I can then choose it as my primary IP. 
> 192.168.4.7 is saved if I choose Save and Exit. Good. Then, if I turn 
> off Listen on All IP Addresses, 192.168.4.7 is replaced with 127.0.0.1, 
> thus recreating my original issue.
> 
> Just now I booted Linux with IPv6 enabled. The mythtv-setup issue with 
> the back end host address is the same: 127.0.0.1 is my only option if I 
> turn off Listen on All IP Addresses.
> 
> Looks like I'm stuck with listening on all IPs...

This looks like it might be a mysql mis-configuration.
Search your my.cnf or the files in my.cnf.d for 'bind-address'
and comment out that line. Restart mysqld. Test.

If you have no bind-address set, then mysql listens ONLY to localhost.
If you have bind-address=0.0.0.0 then mysql listens to any network.

If you have bind-address=192.168.20.20 then *this* mysql instance will 
only accept connections from that IP.
In BE/FE setups, 127.0.0.1 works fine.
If you have a remote front end, the mysql *CLIENT* must be told to 
connect to the mysql server using the server's address.

Not sure from this thread whether yours is a BE/FE or remote FE setup.

Geoff