<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I am having a similar problem, so I
went to look at the user table in mythconveg. I don't seem to have
a user table.<br>
It looks like I do have a users table though.<br>
I'm running mint 18 Cinnamon and did a database restore. This has
left me with liveTV not working, and mythweb not working.<br>
I posted on the forum, but so far it has been a monologue with no
posts by anyone but me.<br>
<a class="moz-txt-link-freetext" href="https://forum.mythtv.org/viewtopic.php?f=36&t=151">https://forum.mythtv.org/viewtopic.php?f=36&t=151</a><br>
(skip down to July 9th to see the current issues and what I have
tried)<br>
<br>
On 07/16/2016 03:43 PM, Steve Greene wrote:<br>
</div>
<blockquote
cite="mid:CAJMGAonLpHxMcqM-1egpVjUi5N8tFfPcmQpVMpQQEMj+W+pqjQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>Thanks for everyone's help and insight. I still haven't
solved this and I'm not about to surrender my Saturday night
to it. I've backed up the recalcitrant install and I'll work
on it as time permits.<br>
<br>
</div>
<div>I'd probably stay with Mint 17.3 if I could get it to
play nicely with all my new Skylake goodies!<br>
</div>
<div><br>
</div>
BTW, I'm really not liking mysql-server-5.7, it demanded a
clean install and replaced one or two cnf files with what
seems like 5-6. Not sure what the users are getting for that
added complexity!<br>
<br>
</div>
Steve<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 16, 2016 at 6:07 PM, Steve
Greene <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:sgreene59@verizon.net" target="_blank">sgreene59@verizon.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<blockquote style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex" class="gmail_quote">mysql>
SELECT user, host from user;<br>
+------------------+-------------+<br>
| user | host |<br>
+------------------+-------------+<br>
| mythtv | % |<br>
| mythtv | 192.168.1.2 |<br>
| mythtv | bilbo.home |<br>
| debian-sys-maint | localhost |<br>
| mysql.sys | localhost |<br>
| root | localhost |<br>
+------------------+-------------+<br>
</blockquote>
<div><br>
</div>
<div>Shouldn't this cover all the locations?<br>
<br>
<br>
</div>
<div>This is super-frustrating, I always expect that a
database restore from a working setup should "just
work". It never does. <br>
<br>
</div>
<div>How do I turn on more helpful debugging messages?
/var/log/mysql/error.log gives me nothing more than what
I've seen from command-line login attempts.<span
class="HOEnZb"><font color="#888888"><br>
</font></span></div>
<span class="HOEnZb"><font color="#888888">
<div><br>
</div>
<div>Steve<br>
</div>
</font></span></div>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 16, 2016 at 5:42
PM, Hika van den Hoven <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:hikavdh@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a></a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hoi
Steve,<br>
<div>
<div><br>
Saturday, July 16, 2016, 11:30:57 PM, you
wrote:<br>
<br>
> I thought that was what mythtv.cnf was
for, which I've set to my<br>
> local ip. I just tried setting
mysqld.cnf<br>
> "bind-address=my_ip_address" and it
hasn't worked.<br>
<br>
> I can still manually call up mysql
-umyth -p, but mysql<br>
> -h192.168.1.x -umyth -p gives me ERROR
1045 (28000): Access denied<br>
> for user 'mythtv'@'my_hostname' (using
password: YES).<br>
> Incidentally, same with the root mysql
account. I can connect from<br>
> my secondary backend via the ip address.
It just won't accept an<br>
> login via the IP address local to the
server.<br>
<br>
> Steve<br>
<br>
> On Sat, Jul 16, 2016 at 3:27 PM, Steve
Greene <<a moz-do-not-send="true"
href="mailto:sgreene59@verizon.net"
target="_blank">sgreene59@verizon.net</a>>
wrote:<br>
<br>
> Since upgrading to 0.28 and Mint 18, my
local frontend connects to<br>
> "localhost" but not the IP address of the
MBE (which is local).<br>
<br>
> mysql -h"my_IP_ADDR" -u myth -p will
fail, but mysql -umythtv -p<br>
> will connect. Do I have to add the IP
address to one of the tables in mythconverg?<br>
<br>
> Thanks in advance for your assistance.<br>
<br>
> Steve<br>
><br>
<br>
</div>
</div>
Have you setup a user for that location in mysql.
You have to setup<br>
the user/password for the locations from where you
want to have<br>
access. So localhost or an IP address or % for all
machines.<br>
<br>
Tot mails,<br>
Hika mailto:<a
moz-do-not-send="true"
href="mailto:hikavdh@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a></a><br>
<br>
"Zonder hoop kun je niet leven<br>
Zonder leven is er geen hoop<br>
Het eeuwige dilemma<br>
Zeker als je hoop moet vernietigen om te kunnen
overleven!"<br>
<br>
De lerende Mens<br>
<div>
<div><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:mythtv-users@mythtv.org"
target="_blank">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>
</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>I am hav<br>
</p>
</body>
</html>