[mythtv] MySQL Database connection through socket fails for MariaDB 10.6

[Gary Buhrmaster]

On Wed, Apr 13, 2022 at 2:19 AM David Engel <david at istwok.net> wrote:

> Commenting out the bind-address line has always worked for me.  Oddly,
> the default value is an empty string but I don't see behavior for that
> officially documented anywhere.

The default for mysql is the equivalent of
bind-address=* (accept any ipv4/ipv6) per
   https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_bind_address

The default for mariadb is actually empty,
which means it also listens on all ipv4/ipv6
addresses per:
  https://mariadb.com/kb/en/server-system-variables/#bind_address

> Seeing as how MariaDB is the de facto "MySQL" on most (all?) other
> distros not named Ubuntu, my feeling is it should officially be
> supported too.

Which, arguably, means mythtv packaging
should not set any bind-address and let all
supported DB servers listen on all (available)
addresses by default (as long as the mythtv
setup creates appropriately secure user
passwords).

Yes, connecting via a local socket can be
more performant, but the differences are
not typically significant for MythTV on
current gen systems.