[mythtv-users] mythtv v29 can't connect remote frontend

[Bill Meek]

On 01/08/2018 09:05 PM, Jim Abernathy wrote:
> I trimmed most of the previous text.
> 
> I went to mariadb.com<http://mariadb.com>  and looked into Configuring for remote Client access.  They say:
> 
>    *   MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).
> 
> This tells me that either of these 2 statements are the same:
> 
> bind-address=::
> #bind-address=::
> 
> So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.

Because it is set in another file (follow the includedirs in the previous post.)

Or, do this: grep -r bind-address /etc/mysql and, at least on my box,
there are two other instances setting it to the 127.... address. These
files are parsed before mythtv.cnf.

-- 
Bill