<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 11/28/2014 10:53 AM, Jay Foster
wrote:<br>
</div>
<blockquote cite="mid:5478C4A2.1080307@roadrunner.com" type="cite">On
11/28/2014 10:42 AM, Bill Meek wrote:
<br>
<blockquote type="cite">On 11/28/2014 12:25 PM, Jay Foster wrote:
<br>
...
<br>
> On my BE system, I have a /etc/mysql/conf.d directory.
There is a mythtv.cnf file there:
<br>
<blockquote type="cite">
<br>
[mysqld]
<br>
#bind-address=0.0.0.0
<br>
max_connections=100
<br>
<br>
Should I edit this file? Should I add a new file? What
should I put in there?
<br>
</blockquote>
<br>
Yes, no and:
<br>
<br>
Uncomment the bind-address line. I *think* you have to
<br>
restart mysql, but haven't changed mine in ages.
<br>
<br>
<blockquote type="cite">Do I still need to do the
<br>
<br>
$ mysql -u root mythconverg
<br>
mysql> grant all on mythconverg.* to mythtv@"192.168.200.%"
identified by "mythtv";
<br>
mysql> flush privileges;
<br>
</blockquote>
<br>
Maybe, you can do:
<br>
<br>
SHOW GRANTS FOR mythtv;
<br>
<br>
to see what's there now. You're looking for something similar to
this:
<br>
<br>
GRANT USAGE ON mythconverg.* TO 'mythtv'@'%' IDENTIFIED BY
PASSWORD '*CC8F35F587CA5A556B4132C2407E556D92172FFC'
<br>
<br>
</blockquote>
Thanks.
<br>
<br>
I first changed the bind-address to 192.168.200.11, but then
changed it back to 0.0.0.0 (INADDR_ANY).
<br>
I restarted mysql and the new FE successfully connected to the
BE.
<br>
<br>
NOTE: I tried the:
<br>
mysql -u root mythconverg
<br>
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using password: NO)
<br>
jay@mythbox:/etc/mysql$ sudo mysql -u root mythconverg
<br>
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using password: NO)
<br>
<br>
but got errors, so I'm glad that I did not need that.
<br>
Jay
<br>
_______________________________________________
<br>
mythtv-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<br>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
<br>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
<br>
<br>
</blockquote>
Arrg. I spoke too soon. Now mythweb no longer works. I now get<br>
<br>
<h2>Fatal Error</h2>
!!NoTrans: Can't connect to MySQL server on '127.0.0.1' (111)
[#2003]<br>
<br>
when I try to use mythweb.<br>
<br>
Jay<br>
</body>
</html>