[mythtv-users] BE3 - Issues with installation and database

[Stephen Worthington]

On Tue, 21 May 2019 19:50:07 -0500, you wrote:

>On 5/21/19 6:12 PM, Barry Martin wrote:
>> 
>>     barry at Backend-3:~$ sudo mysql --host=localhost --user=mythtv
>>     --password=Z*******S mythconverg
>> 
>>     ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost'
>>     (using password: YES)
>> 
>>     barry at Backend-3:~$
>> 
>> 
>> So far not so good, but appreciate the help!
>
>
>    MariaDB [(none)]> SHOW GRANTS FOR 'mythtv'@'127.0.0.1';
>
>    ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on host '127.0.0.1'
>
>If you'd like permissions for 127.0.0.1, just add it the same way others
>we added.

It should not be necessary to do that, as you already have permissions
set for 'mythtv'@'%', which will match 'mythtv'@'127.0.0.1'.

>You can compare the encrypted password seen in the output of
>SHOW GRANTS with the value returned with:
>
>     SELECT PASSWORD('Z*******S');
>
>Or, look at all host/user/passwords with:
>
>     SELECT Host,User,Password FROM user ORDER BY User,Host;
>
>They must match. config.xml should have the same credentials.

That SELECT will not work unless you do:

use mysql;

first.  The 'user' table is in the 'mysql' database.  MariaDB and
MySQL store most of their administrative data in the 'mysql' database,
including some of the user data.