[mythtv-users] Cannot Connect To Backend

[Hika van den Hoven]

Hoi Jay,

Friday, November 28, 2014, 7:53:22 PM, you 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
> _______________________________________________

The error means you have a password set for the root user. You
probably set it when installing. Possibly it is the same as the one
for mythtv. Try adding the -p switch. If you omit the password it
should ask for one.

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