[mythtv-users] Cannot Connect To Backend

Jay Foster jayf0ster at roadrunner.com
Fri Nov 28 18:53:22 UTC 2014


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


More information about the mythtv-users mailing list