<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Bill!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">If: mysql --host=localhost --user=mythtv --password=yourPassword mythconverg
works, then the backend will work too (with the same credentials in config.xml.)</pre>
<dl>
<dd>
<table width="620" cellspacing="0" cellpadding="4">
<colgroup><col width="610"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="610" valign="top">
<p>mysql --host=localhost --user=mythtv
--password=Z******S mythconverg</p>
<p><br>
</p>
<p>OK, so this appears to work properly:</p>
<p><br>
</p>
<p>barry@Backend-3:~$ </p>
<p>barry@Backend-3:~$ </p>
<p>barry@Backend-3:~$ mysql --host=localhost
--user=mythtv --password=ZR4MgvsS mythconverg</p>
<p>Reading table information for completion of table and
column names</p>
<p>You can turn off this feature to get a quicker
startup with -A</p>
<p><br>
</p>
<p>Welcome to the MariaDB monitor. Commands end with ;
or \g.</p>
<p>Your MariaDB connection id is 141</p>
<p>Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2
Ubuntu 18.04</p>
<p><br>
</p>
<p>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation
Ab and others.</p>
<p><br>
</p>
<p>Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.</p>
<p><br>
</p>
<p>MariaDB [mythconverg]> </p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>And with the static IP address:</p>
<p><br>
</p>
<p>barry@Backend-3:~$ mysql --host=192.168.0.3
--user=mythtv --password=Z******S mythconverg</p>
<p>Welcome to the MariaDB monitor. Commands end with ;
or \g.</p>
<p>Your MariaDB connection id is 142</p>
<p>Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2
Ubuntu 18.04</p>
<p><br>
</p>
<p>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation
Ab and others.</p>
<p><br>
</p>
<p>Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.</p>
<p><br>
</p>
<p>MariaDB [mythconverg]> status</p>
<p>--------------</p>
<p>mysql Ver 15.1 Distrib 10.1.38-MariaDB, for
debian-linux-gnu (x86_64) using readline 5.2</p>
<p><br>
</p>
<p>Connection id: 142</p>
<p>Current database: mythconverg</p>
<p>Current user: <a class="moz-txt-link-abbreviated" href="mailto:mythtv@192.168.0.3">mythtv@192.168.0.3</a></p>
<p>SSL: Not in use</p>
<p>Current pager: stdout</p>
<p>Using outfile: ''</p>
<p>Using delimiter: ;</p>
<p>Server: MariaDB</p>
<p>Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2
Ubuntu 18.04</p>
<p>Protocol version: 10</p>
<p>Connection: 192.168.0.3 via TCP/IP</p>
<p>Server characterset: utf8mb4</p>
<p>Db characterset: utf8</p>
<p>Client characterset: utf8mb4</p>
<p>Conn. characterset: utf8mb4</p>
<p>TCP port: 3306</p>
<p>Uptime: 30 min 4 sec</p>
<p><br>
</p>
<p>Threads: 1 Questions: 475 Slow queries: 0 Opens: 111
Flush tables: 1 Open tables: 105 Queries per second
avg: 0.263</p>
<p>--------------</p>
<p><br>
</p>
<p><br>
</p>
<p>Tried <b>mythtv-setup</b> 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.</p>
<p><br>
</p>
<p>Thanks!</p>
<p>Barry</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p>
<style type="text/css">td p { margin-bottom: 0in; }pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></p>
<br>
</body>
</html>