[mythtv-users] Can't connect to remote backend database

[Jan Ceuleers]

On 05/06/2021 08:26, Phill Edwards wrote:
> I built a new backend based on Ubuntu 20.04. But I haven't been able to
> configure it to allow connections from remote frontends. That's a
> problem because my frontend is a separate machine to my backend. 
> 
> I've followed steps from https://www.mythtv.org/wiki/Database_Setup
> <https://www.mythtv.org/wiki/Database_Setup>. 
> 
> And I've changed the bind-address settings in the mysql conf files:
> 
> /etc/mysql/mysql.conf.d/mysqld.cnf
> ...
> bind-address            = 0.0.0.0
> mysqlx-bind-address     = 0.0.0.0
> ...
> 
> 
> /etc/mysql/mysql.conf.d/mythtv.cnf
> [mysqld]
> bind-address=0.0.0.0
> max_connections=100

What works on my machine is to bind mysql to the actual LAN IP address
of the machine hosting the database, so not the wildcard 0.0.0.0 address.

mysqld]
bind-address=192.168.1.60
max_connections=100
table_open_cache=500