[mythtv-users] Cannot Connect To Backend

[Hika van den Hoven]

Hoi Hika,

Friday, November 28, 2014, 7:39:19 PM, you wrote:

> Hoi Jay,

> Friday, November 28, 2014, 7:25:16 PM, you wrote:

>> On 11/28/2014 09:42 AM, Bill Meek wrote:
>>> On 11/28/2014 11:35 AM, Hika van den Hoven wrote:
>>>> Look in probably /etc/mysql/my.cnf for bind-address
>>>
>>> Even better, check the note near the bottom of this link:
>>>
>>> https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#Modifying_access_to_the_MySQL_database_for_multiple_systems
>>>
>>> You shouldn't touch my.cnf if the line (and note) says:
>>>
>>>     !includedir /etc/mysql/conf.d/
>>>
>> 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

> Add a line: bind-address=<fill in you backend-address>

>> Should I edit this file?  Should I add a new file?  What should I put in
>> there?

>> 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;

> Doing this if it's already set wont harm.

>> from the wiki?

>> Jay
>> _______________________________________________

> You can test on your new frontend with:
> mysql -u<your mysqluser> -h<your backend ip> -p<your mysql password>
> mythconverg
> On one line to test if it will connect.

> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com

To clarify uncommenting like Bill says will make it bind to all
addresses. Setting a specific address only to that one. It's what
you want.


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