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

[R. G. Newbury]

On 2021-07-04 6:40 p.m., Phill Edwards wrote:
> Back in June I posted a problem where I couldn't connect any remote 

> This is my list of users:
> mysql> select host,user from mysql.user;
> +-------------+------------------+
> | host        | user             |
> +-------------+------------------+
> | %           | mythtv           |
> | 192.168.0.% | mythtv           |
> | localhost   | debian-sys-maint |
> | localhost   | mysql.infoschema |
> | localhost   | mysql.session    |
> | localhost   | mysql.sys        |
> | localhost   | root             |
> +-------------+------------------+

Run that mysql query again, but use:

select host, user, password from mysql.user;

So you can check if the (hash of the) passwords are the same. I have 
never seemed to have had any luck with using the '%' wildcard for 
connections. So I specify each one by IP:

MariaDB [(none)]> select host,user,password from mysql.user where user = 
"mythtv";
+-------------------+--------+-------------------------------------------+
| host              | user   | password                                  |
+-------------------+--------+-------------------------------------------+
| localhost         | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC 
| 192.168.1.99      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC
| 192.168.1.96      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC 
| 192.168.1.95      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC 
| 192.168.1.86      | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC

Those are the main desktop, the mythbox and the laptop (wired and 
wireless) as set in /etc/hosts and on each computer.
Works for me.
Note: if you are using SchedulesDirect JSON you will have an 'sd' user too.

Geoff