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

[Stephen Worthington]

On Sat, 5 Jun 2021 16:26:07 +1000, you 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.
>
>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).

Have you checked that there is not still another bind-address setting
somewhere in the config files that is overriding your new setting?

sudo su
cd /etc/mysql
grep -ir "bind-address" *

Unless you are willing to look up all the rules and figure out which
*.cnf file is loaded last, there should be only one bind-address=
which is not commented out anywhere in all the *.cnf files.  And the
order the *.cnf files are loaded differs between MySQL and MariaDB,
just to confuse things further.

If you have IPv6 enabled, set bind-address=:: instead of
bind-address=0.0.0.0.