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

[Barry Martin]

Hi Bill!


If: mysql --host=localhost --user=mythtv --password=yourPassword mythconverg
works, then the backend will work too (with the same credentials in config.xml.)

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


    OK, so this appears to work properly:


    barry at Backend-3:~$

    barry at Backend-3:~$

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

    Reading table information for completion of table and column names

    You can turn off this feature to get a quicker startup with -A


    Welcome to the MariaDB monitor. Commands end with ; or \g.

    Your MariaDB connection id is 141

    Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04


    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


    Type 'help;' or '\h' for help. Type '\c' to clear the current input
    statement.


    MariaDB [mythconverg]>




    And with the static IP address:


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

    Welcome to the MariaDB monitor. Commands end with ; or \g.

    Your MariaDB connection id is 142

    Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04


    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


    Type 'help;' or '\h' for help. Type '\c' to clear the current input
    statement.


    MariaDB [mythconverg]> status

    --------------

    mysql Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu
    (x86_64) using readline 5.2


    Connection id: 142

    Current database: mythconverg

    Current user: mythtv at 192.168.0.3

    SSL: Not in use

    Current pager: stdout

    Using outfile: ''

    Using delimiter: ;

    Server: MariaDB

    Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04

    Protocol version: 10

    Connection: 192.168.0.3 via TCP/IP

    Server characterset: utf8mb4

    Db characterset: utf8

    Client characterset: utf8mb4

    Conn. characterset: utf8mb4

    TCP port: 3306

    Uptime: 30 min 4 sec


    Threads: 1 Questions: 475 Slow queries: 0 Opens: 111 Flush tables: 1
    Open tables: 105 Queries per second avg: 0.263

    --------------



    Tried *mythtv-setup* at Terminal – it whined but we didn’t alter
    anything since last message. Gave: ERROR 1142 (42000) at line 1:
    SELECT command denied to user ‘mythtv’@’192.168.0.3’ for table
    ‘settings’. (Followed by two Gtk-Message errors.) LIS, appears to be
    a permissions thing.


    Thanks!

    Barry




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190525/04df8ec8/attachment.html>