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

[Bill Meek]

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.

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.

-- 
Bill