[mythtv-users] Cannot Connect To Backend

[Jay Foster]

On 11/28/2014 10:53 AM, Jay Foster wrote:
> On 11/28/2014 10:42 AM, Bill Meek wrote:
>> On 11/28/2014 12:25 PM, Jay Foster wrote:
>> ...
>> > On my BE system, I have a /etc/mysql/conf.d directory. There is a 
>> mythtv.cnf file there:
>>>
>>> [mysqld]
>>> #bind-address=0.0.0.0
>>> max_connections=100
>>>
>>> Should I edit this file?  Should I add a new file?  What should I 
>>> put in there?
>>
>> Yes, no and:
>>
>> Uncomment the bind-address line. I *think* you have to
>> restart mysql, but haven't changed mine in ages.
>>
>>> Do I still need to do the
>>>
>>> $ mysql -u root mythconverg
>>> mysql> grant all on mythconverg.* to mythtv@"192.168.200.%" 
>>> identified by "mythtv";
>>> mysql> flush privileges;
>>
>> Maybe, you can do:
>>
>>     SHOW GRANTS FOR mythtv;
>>
>> to see what's there now. You're looking for something similar to this:
>>
>>     GRANT USAGE ON mythconverg.* TO 'mythtv'@'%' IDENTIFIED BY 
>> PASSWORD '*CC8F35F587CA5A556B4132C2407E556D92172FFC'
>>
> Thanks.
>
> I first changed the bind-address to 192.168.200.11, but then changed 
> it back to 0.0.0.0 (INADDR_ANY).
> I restarted mysql and the new FE  successfully connected to the BE.
>
> NOTE: I tried the:
> mysql -u root mythconverg
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
> jay at mythbox:/etc/mysql$ sudo mysql -u root mythconverg
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
>
> but got errors, so I'm glad that I did not need that.
> Jay
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
Arrg.  I spoke too soon.  Now mythweb no longer works.  I now get


    Fatal Error

!!NoTrans: Can't connect to MySQL server on '127.0.0.1' (111) [#2003]

when I try to use mythweb.

Jay
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20141128/9887434b/attachment.html>