[mythtv-users] Cannot Connect To Backend
Jay Foster
jayf0ster at roadrunner.com
Fri Nov 28 21:48:45 UTC 2014
On 11/28/2014 01:06 PM, Hika van den Hoven wrote:
> Hoi Jay,
>
> Friday, November 28, 2014, 9:44:59 PM, you wrote:
>
>> 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
>>
>
>
> What does: mysql -u<your mysqluser> -hlocalhost -p<your mysqlpassword> mythconverg
> give?
> Tot mails,
> Hika mailto:hikavdh at gmail.com
>
> "Zonder hoop kun je niet leven
> Zonder leven is er geen hoop
> Het eeuwige dilemma
> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>
> De lerende Mens
>
> _______________________________________________
> 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
>
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 193
Server version: 5.5.40-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql>
Jay
More information about the mythtv-users
mailing list