[mythtv-users] Can't connect to database

[Damian]

On 03/05/2020 19:54, Bill Meek wrote:
> On 5/3/20 1:32 PM, Damian wrote:
>>
>>> If
>>> it is the +++ one, then the bindaddress=127.0.0.1 line has been
>>> uncommented, so it could be overriding your real bindaddress line in
>>> another settings file.
>> I had my fingers crossed that the solution would be that simple. So, 
>> I added # before the line, logged out and logged back in again.
>>
>> I was still taken to the same waiting for database screen.
>>
>> (I've taken the # back out of the bind-address. Let me know if it 
>> should definitely be there).
>
> Changes should never be made in /etc/mysql/mysql.conf.d/mysqld.cnf 
> because they
> can be overridden by a package maintainer.
>
> Rather, create a file such as: /etc/mysql/mysql.conf.d/mythtv.cnf

Thanks Bill,

That file already existed, and had the bind-address commented out.

> In this specific case, to change the bind-address, add:
>
> [mysqld]
> bind-address=::
I replaced
#bind-address=0.0.0.0

with
bind-address=::

Restarted mysql (with sudo /etc/init.d/mysql restart)
And it worked!

I assume that bind-address=:: is 'too open'?

So, I tried
bind-address=127.0.0.1
but that didn't work.

However,
bind-address=192.168.0.4
did work!

Should I keep it like that?

Thanks Bill!!