[mythtv-users] Ver 31 frontend cannot connect to the database

[Mike Carron]

On 11/23/20 6:09 PM, Stephen Worthington wrote:
> On Mon, 23 Nov 2020 16:57:05 -0800, you wrote:
>
>> On 11/23/20 7:13 AM, Bill Meek wrote:
>>
>>     |
>>
>>     snip
>>
>>     |
>>
>>     At least my /etc/mysql/mariadb.conf.d/50-server.cnf, appears to
>>     be one that would be released by a package manager and changes to
>>     it could be overwritten by updates/upgrades.
>>
>>     I'd move the mythtv.cnf file to /etc/mysql/mariadb.conf.d to
>>     prevent future surprises.
>>
>> I've gone over everything and I have to conclude that port 3306 on the
>> backend being closed is the culprit. Since mythfrontend wants to use
>> port 3306 to communicate with the backend I'm not going to get anywhere
>> until port 3306 is opened. Unfortunately I do not know how to do that.
>>
>> How do I open port 3306?
>>
>> mike
> As I said, fix the MariaDB bind-address.  Port 3306 is the port for
> MariaDB, not MythTV.  MariaDB is still binding to 3306 only on
> localhost.  It needs to bind 3306 on all IP addresses.

How do I do that?

mike