[mythtv-users] Cannot Connect To Backend

[Hika van den Hoven]

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