<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">mysql> SELECT host,user FROM user;<br>
+-----------+------------------+<br>
| host | user |<br>
+-----------+------------------+<br>
| % | mythtv |<br>
| localhost | debian-sys-maint |<br>
| localhost | mysql.sys |<br>
| localhost | mythtv |<br>
| localhost | root |<br>
+-----------+------------------+<br>
5 rows in set (0.00 sec)<br>
<br>
Doesn't seem any different from the command mark perkens asked me
to run.<br>
<br>
On 07/16/2016 06:51 PM, Steve Greene wrote:<br>
</div>
<blockquote
cite="mid:CAJMGAokwz-3L3tv067E9yvZptnSY-Vp3u-KS5+LJJ_i7z2frQw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>start with use mysq;, then SELECT host,user FROM user<br>
<br>
</div>
I think you should be looking at mysql permissions, not just
those related to your backend database.<br>
<br>
</div>
Steve<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 16, 2016 at 9:44 PM, Mark
Perkins <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:perkins1724@hotmail.com" target="_blank">perkins1724@hotmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class="">On 17 July 2016 8:44:24 AM ACST, Douglas Peale
<<a moz-do-not-send="true"
href="mailto:Douglas_Peale@comcast.net">Douglas_Peale@comcast.net</a>>
wrote:<br>
>I am having a similar problem, so I went to look at
the user table in<br>
>mythconveg. I don't seem to have a user table.<br>
<br>
</span>What does this return from a terminal prompt on the
backend (assuming it is also hosting your mysql database).
Use your root mysql password:<br>
<br>
mysql -uroot -p -e "select host,user from mysql.user"<br>
<br>
If you really do have a 'mysql.users' table and not a
'mysql.user' table then that would be beyond me but i am not
a mysql expert.<br>
<span class="im HOEnZb">--<br>
Sent from mobile device. Please excuse brevity.<br>
</span>
<div class="HOEnZb">
<div class="h5">_______________________________________________<br>
mythtv-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a moz-do-not-send="true"
href="http://lists.mythtv.org/mailman/listinfo/mythtv-users"
rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a moz-do-not-send="true"
href="http://wiki.mythtv.org/Mailing_List_etiquette"
rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a moz-do-not-send="true"
href="https://forum.mythtv.org" rel="noreferrer"
target="_blank">https://forum.mythtv.org</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>