[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