[mythtv-users] Help! New Frontend box cannot connect to master backend in setup.

[Allen Edwards]

Nick Morrott wrote:
> On 08/08/2008, Allen Edwards <allen.edwards at oldpaloalto.com> wrote:
> 
>>  I reinstalled mythbuntu a 4th time far enough that I could get a command
>>  prompt and had mysql installed.
>>  I issued this command:
>>  mysql -h 192.168.1.111 -u root -p
>>  I entered my password and cannot connect.
>>
>>
>>  I guess that points to the backend, but what?  I have checked all the
>>  settings in myth three times.
> 
> More likely an access issue with your MySQL installation, which is
> denying access to remote hosts. Check your /etc/my.cnf on the DB host
> in case it is binding to localhost, and if that is not the case, you
> may have to grant access for your remote machines to the MythTV
> database directly - instructions can be found in the MythTV docs and
> on the wiki.
> 
Thank you.  I think that must be it.

That file has:
bind-address            = 127.0.0.1

which, according to the wiki I need to comment out.  Can't try it until 
"So You Think You Can Dance" is over -- my family would kill me if I 
messed up their watching of the show by locking up some database...

I think you have put me on the right track and I thank you again.

Allen