[mythtv-users] mythfrontend can't connect to backend/database

[Steve Wilson]

--- starcycle <starcycle at gmail.com> wrote:

> god this is frustrating. out of curiosity I launched
> mythfrontend on
> the server, and that works fine. so apparently it's
> a network problem?
> 
> the ports should already be accessible to the LAN,
> but I explicitly
> opened them anyway, 3066 for mysql and 6543:6544 for
> mythtv. but still
> no go.
> 
> I followed all the tutorials for allowing network
> access in
> /etc/mysql/my.cnf (commenting out # localhost,
> etc.), and added
> askip-innodb and set-variable=thread_stack=256k as
> specified for
> connection problems in the mythtv doc, but I must
> have missed
> something. this is really kicking my butt! <grr>
> something is
> configured wrong somewhere to allow network access,
> but i'm out of
> ideas.
> 
> do you need to specify anything for mythtv or mysql
> in
> /etc/hosts.allow and .deny? I didn't think you need
> to for mysql at
> least.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 

When you setup the database, how did you grant
permissions. Something like this will work but it has
no security so you'll want to do this as a test.

mysql> grant all on mythconverg.* to mythtv@"%"
identified by "mythtv";
mysql> flush privileges;


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ