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

[Barry Martin]

Hi Bill!


MariaDB [(none)]> show grants;

The [(none)] above is because you haven't selected a database on the 
command line. Not a problem.

SHOW GRANTS only shows grants for the current user. Use:

      *SHOW GRANTS FOR 'mythtv'@'localhost';*

    OK,just so we know where I am on this end starting from being
    powered off all night *service --status-all*displaying {+} mysql,
    [+] mythtv-backend.


    ...Your command (using sudo mysql) results, plus a little other testing:



    MariaDB [(none)]> SHOW GRANTS FOR 'mythtv'@'localhost';

    +---------------------------------------------------------------------------------------------------------------+

    | Grants for mythtv at localhost |

    +---------------------------------------------------------------------------------------------------------------+

    | GRANT USAGE ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY PASSWORD
    '*<random one deleted>' |

    | GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'localhost' |

    +---------------------------------------------------------------------------------------------------------------+

    2 rows in set (0.00 sec)


    MariaDB [(none)]>

    MariaDB [(none)]> SHOW GRANTS FOR 'mythtv'@'192.168.0.3';

    +-----------------------------------------------------------------------------------------------------------------+

    | Grants for mythtv at 192.168.0.3 |

    +-----------------------------------------------------------------------------------------------------------------+

    | GRANT USAGE ON *.* TO 'mythtv'@'192.168.0.3' IDENTIFIED BY
    PASSWORD '*<random one deleted>' |

    | GRANT CREATE TEMPORARY TABLES ON `mythconverg`.* TO
    'mythtv'@'192.168.0.3' |

    +-----------------------------------------------------------------------------------------------------------------+

    2 rows in set (0.00 sec)


    MariaDB [(none)]>

    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'

    MariaDB [(none)]>



    So it seems it’s not liking 127.0.0.1 and gives two different
    answers to localhost and 192.168.0.3.


for example, to see the mythtv user on the localhost.

The: Query OK, <0 or 1> rows affected (0.01 sec) responses are correct 
for the commands you entered.

Another good test to see if the DB is accessible by MythTV is this:

      *mysql --host=localhost --user=mythtv --password=Z******S mythconverg*

    Flunked. :(


    (Yes, did unblock the asterisk'ed password!)


    barry at Backend-3:~$ mysql --host=localhost --user=mythtv
    --password=Z******sS mythconverg

    ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost'
    (using password: YES)

    barry at Backend-3:~$

    barry at Backend-3:~$

    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!

Barry



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190521/12794c31/attachment.html>