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

Stephen Worthington stephen_agent at jsw.gen.nz
Sat Jun 5 07:21:38 UTC 2021

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:
>bind-address            =
>mysqlx-bind-address     =
>Can anyone advise what I need to do to allow remote database connections to
>(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

More information about the mythtv-users mailing list