<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<pre class="western">
</pre>
<p style="margin-bottom: 0in; line-height: 100%">Ah! Per man-page:
mysql db_name:</p>
<p style="margin-bottom: 0in; line-height: 100%"> So mysql
mythconverg</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Take Two...</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><a class="moz-txt-link-freetext" href="https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables">https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">To see if the
tables
are already loaded (using the same query that
mythbackend/mythtv-setup uses to check them) start mysql. </p>
<p style="margin-bottom: 0in; line-height: 100%"> So per Man-Page
should be </p>
<p style="margin-bottom: 0in; line-height: 100%"> shell> mysql
db_name</p>
<p style="margin-bottom: 0in; line-height: 100%"> Or:</p>
<p style="margin-bottom: 0in; line-height: 100%"> shell> mysql
--user=user_name --password=your_password db_name</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> So let's try mysql
mythconverg ==></p>
<p style="margin-bottom: 0in; line-height: 100%"> barry@Backend-3:~$
mysql mythconverg</p>
<p style="margin-bottom: 0in; line-height: 100%"> ERROR 1045
(28000):
Access denied for user 'barry'@'localhost' (using password: NO)</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> barry@Backend-3:~$
</p>
<p style="margin-bottom: 0in; line-height: 100%"> barry@Backend-3:~$
sudo mysql mythconverg</p>
<p style="margin-bottom: 0in; line-height: 100%"> Reading table
information for completion of table and column names</p>
<p style="margin-bottom: 0in; line-height: 100%"> You can turn off
this feature to get a quicker startup with -A</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> Welcome to the
MariaDB monitor. Commands end with ; or \g.</p>
<p style="margin-bottom: 0in; line-height: 100%"> Your MariaDB
connection id is 146</p>
<p style="margin-bottom: 0in; line-height: 100%"> Server version:
10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> Copyright (c)
2000,
2018, Oracle, MariaDB Corporation Ab and others.</p>
<p style="margin-bottom: 0in; line-height: 100%"> </p>
<p style="margin-bottom: 0in; line-height: 100%"> Type 'help;' or
'\h' for help. Type '\c' to clear the current input statement.</p>
<p style="margin-bottom: 0in; line-height: 100%"> </p>
<p style="margin-bottom: 0in; line-height: 100%"> MariaDB
[mythconverg]></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Much better!!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"> </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Continuing with
<a class="moz-txt-link-freetext" href="https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables">https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a>:</p>
<p style="margin-bottom: 0in; line-height: 100%">
<style type="text/css">p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">For 0.27+, type:</p>
<p style="margin-bottom: 0in; line-height: 100%">SELECT
CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">+----------------------------------------+</p>
<p style="margin-bottom: 0in; line-height: 100%">| CONVERT_TZ(NOW(),
'SYSTEM', 'Etc/UTC') | Got this (as expected)</p>
<p style="margin-bottom: 0in; line-height: 100%">+----------------------------------------+</p>
<p style="margin-bottom: 0in; line-height: 100%">| NULL |</p>
<p style="margin-bottom: 0in; line-height: 100%">+----------------------------------------+</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">then the tables
must
be loaded.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Assuming the
distribution's time zone information is in /usr/share/zoneinfo,
type:</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">mysql_tzinfo_to_sql
/usr/share/zoneinfo | mysql -u root -p mysql</p>
<p style="margin-bottom: 0in; line-height: 100%"> <== has to be a
Terminal command as no ';'</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql</p>
<p style="margin-bottom: 0in; line-height: 100%">Enter password:
(B***6)</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1698 (28000):
Access denied for user 'root'@'localhost'</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql</p>
<p style="margin-bottom: 0in; line-height: 100%">Enter password:
(Z***S)</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1698 (28000):
Access denied for user 'root'@'localhost'</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Well at least I
figured out one problem. %)</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western"><style type="text/css">p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></pre>
<style type="text/css">pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style>
</body>
</html>