[mythtv-users] Cannot Connect To Backend

[Hika van den Hoven]

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

"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