<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"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">MariaDB [(none)]> show grants;</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">The [(none)] above is because you haven't selected a database on the command line. Not a problem.</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">SHOW GRANTS only shows grants for the current user. Use:</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><b>SHOW GRANTS FOR 'mythtv'@'localhost';</b></span></font></font>
</pre>
<dl>
<dd>
<table width="633" cellspacing="0" cellpadding="4">
<colgroup><col width="623"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="623" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">OK,just so we
know where I am on this end starting from being
powered off all night <b>service --status-all</b><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal"> displaying {+}
mysql, [+] mythtv-backend.</span></span></span></font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">...</span></span></span><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">Your command
(using sudo mysql) results, plus a little
other testing:</span></span></span></font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> SHOW GRANTS FOR
'mythtv'@'localhost';</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+---------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| Grants for
mythtv@localhost |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+---------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| GRANT USAGE ON
*.* TO 'mythtv'@'localhost' IDENTIFIED BY
PASSWORD '*<random one deleted>' |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| GRANT ALL
PRIVILEGES ON `mythconverg`.* TO
'mythtv'@'localhost' |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+---------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">2 rows in set
(0.00 sec)</span></span></span></font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> </span></span></span></font></font>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> SHOW GRANTS FOR
'mythtv'@'192.168.0.3';</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+-----------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| Grants for
<a class="moz-txt-link-abbreviated" href="mailto:mythtv@192.168.0.3">mythtv@192.168.0.3</a> |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+-----------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| GRANT USAGE ON
*.* TO 'mythtv'@'192.168.0.3' IDENTIFIED BY
PASSWORD '*<random one deleted>' |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">| GRANT CREATE
TEMPORARY TABLES ON `mythconverg`.* TO
'mythtv'@'192.168.0.3' |</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">+-----------------------------------------------------------------------------------------------------------------+</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">2 rows in set
(0.00 sec)</span></span></span></font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> </span></span></span></font></font>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> SHOW GRANTS FOR
'mythtv'@'127.0.0.1';</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">ERROR 1141
(42000): There is no such grant defined for
user 'mythtv' on host '127.0.0.1'</span></span></span></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">MariaDB
[(none)]> </span></span></span></font></font>
</p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><span
style="font-style: normal"><span
style="text-decoration: none"><span
style="font-weight: normal">So it seems it’s
not liking 127.0.0.1 and gives two different
answers to localhost and 192.168.0.3.</span></span></span></font></font></p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">for example, to see the mythtv user on the localhost.</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">The: Query OK, <0 or 1> rows affected (0.01 sec) responses are correct for the commands you entered.</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Another good test to see if the DB is accessible by MythTV is this:</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><b>mysql --host=localhost --user=mythtv --password=Z******S mythconverg</b></span></font></font>
</pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Flunked. :(</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">(Yes, did unblock the asterisk'ed
password!)</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ mysql --host=localhost
--user=mythtv --password=Z******sS mythconverg</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">ERROR 1045 (28000): Access denied for
user 'mythtv'@'localhost' (using password: YES)</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ </font></font> </p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ </font></font> </p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ sudo mysql
--host=localhost --user=mythtv
--password=Z*******S mythconverg</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">ERROR 1045 (28000): Access denied for
user 'mythtv'@'localhost' (using password: YES)</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ </font></font> </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%">So far not so good,
but appreciate the help!</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry</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>