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

[Phill Edwards]

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.

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


Can anyone advise what I need to do to allow remote database connections to
mysql?

(The irony is the native mythfrontend is proving very difficult to connect,
yet 3rd party apps such as Android Leanfront and Kodi have no problem at
all because they're using APIs).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210605/78fb2f9e/attachment.htm>