<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Bill!</p>
<br>
<p style="margin-bottom: 0in; line-height: 100%">
<blockquote type="cite">
<pre class="western"> mysql --user=mythtv --password --host=<your DB IP or hostname> mythconverg
Retry with: --host=localhost if the IP address was used please.
</pre>
</blockquote>
<br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">(1) First command
line’s results:</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
mysql --user=mythtv --password --host=192.168.4.3 mythconverg </p>
<p style="margin-bottom: 0in; line-height: 100%">Enter password: </p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1045 (28000):
Access denied for user 'mythtv'@'192.168.4.3' (using password:
YES)</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%">I'll assume
"password: Yes" means it is being used as it asked for it.</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%">(1a) OK, maybe
stupidly put in the address the database seems to think it wants:
(The original IP)</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
mysql --user=mythtv --password --host=192.168.0.3 mythconverg </p>
<p style="margin-bottom: 0in; line-height: 100%">Enter password: </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Eventually timed
out.</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%">(2) The second
“Retry” command line result:</p>
<p style="margin-bottom: 0in; line-height: 100%">barry@Backend-3:~$
mysql --user=mythtv --password --host=localhost mythconverg </p>
<p style="margin-bottom: 0in; line-height: 100%">Enter password: </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 1356</p>
<p style="margin-bottom: 0in; line-height: 100%">Server version:
10.1.44-MariaDB-0ubuntu0.18.04.1 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%"><br>
</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%"><br>
</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%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">OK, that looks
semi-promising. Typed 'exit' as I no instructions on what to do
next. Well, while I’m in the database; I do have this to do:</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">
</pre>
<p style="margin-bottom: 0in; line-height: 100%">
<blockquote type="cite">
<pre class="western">Remove ~/.mythtv/config.xml and link it to the one in /etc:
ln -s /etc/mythtv/config.xml ~/.mythtv/config.xml</pre>
</blockquote>
<br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Checked and “etc’s”
has host=localhost. (Just verifying before doing! Not that I don’t
trust but want to make sure we’re not accidentally creating a
bigger problem.)</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">ls
~/.mythtv/config.xml ==> now is light blue on black, so must be
the “I’m a link” colour. cat /home/barry/.mythtv/config.xml looks
good. </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Thanks!</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>
<p>
<style type="text/css">
pre.cjk { font-family: "Courier New", monospace }
p { margin-bottom: 0.1in; line-height: 115% }
a:link { so-language: zxx }</style></p>
<p><br>
</p>
</body>
</html>