[mythtv-users] Update: problem solved! Thank you! Details inside.

[James Linder]

> On 15 Jan 2021, at 10:57 am, A. F. Cano <afc54 at comcast.net> wrote:
> 
> MariaDB [mythconverg]> grant all on mythconverg.* to 'mythtv'@'%' identified by 'mythtv' with grant option

That works on ubuntu but on at least SuSE it does not

on ubuntu % matches 123.123.123.x and 'localhost'
on suse it does not, you need a grant for 'localhost'
and a grant for '%'

Sounds bizare but it bit me:

MariaDB [mysql]> select host,user from user;
+-------------+-------------+
| Host        | User        |
+-------------+-------------+
| 192.168.5.% | mythtv      |
| localhost   |             |
| localhost   | mariadb.sys |
| localhost   | mysql       |
| localhost   | mythtv      |
| localhost   | root        |
| sandypit    |             |
| sandypit    | mythtv      |
+-------------+-------------+


with '%', 'mythtv' mythbackend would not start. Without 'sandypit' mythconverg_backup.pl would not run

James

ps I assume % would match 'sandypit' and 'localhost' just did not try.
James