[mythtv-users] Cannot Connect To Backend

[Bill Meek]

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'

-- 
Bill