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

[Barry Martin]

Ah! Per man-page: mysql db_name:

So mysql mythconverg



Take Two...


https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables


To see if the tables are already loaded (using the same query that 
mythbackend/mythtv-setup uses to check them) start mysql.

So per Man-Page should be

shell> mysql db_name

Or:

shell> mysql --user=user_name --password=your_password db_name


So let's try mysql mythconverg ==>

barry at Backend-3:~$ mysql mythconverg

ERROR 1045 (28000): Access denied for user 'barry'@'localhost' (using 
password: NO)


barry at Backend-3:~$

barry at Backend-3:~$ sudo mysql 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 146

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]>


Much better!!



Continuing with https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables:


For 0.27+, type:

SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');


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

| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') | Got this (as expected)

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

| NULL |

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


then the tables must be loaded.


Assuming the distribution's time zone information is in 
/usr/share/zoneinfo, type:


mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

<== has to be a Terminal command as no ';'



barry at Backend-3:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u 
root -p mysql

Enter password: (B***6)

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

barry at Backend-3:~$


barry at Backend-3:~$

barry at Backend-3:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u 
root -p mysql

Enter password: (Z***S)

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

barry at Backend-3:~$



Well at least I figured out one problem. %)

Barry



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190526/9acd1479/attachment-0001.html>