[mythtvnz] Frontend cannot connect to database...

[Stephen Worthington]

On Sat, 03 Sep 2011 16:12:51 +1200, you wrote:

>I am setting up a front end and it cannot connect to the backends database.
>
>When  I run the frontend it hangs at "New DB connection, total: 1"
>
>The passwords, names of database, user etcetera match on the frontend 
>and backend.
>
>A connection is made. the backend log reports "2011-09-03 16:09:14.911 
>MainServer, Warning: Unknown socket closing MythSocket(0x9990850)" when 
>I start and close the frontend.
>
>I am not sure what to do next.  My memory tells me that MySQL out of the 
>box does not accept remote queries but I cannot remember how to check.
>
>What is my best path forward?
>
>cheers
>Worik

Are you using Mythbuntu?  In the Mythbuntu Control Center on the MySQL
tab, there is an option for setting the 4 digit Security Key for
remote access.  I have never used remote access, so I can not say how
it works, but I am guessing that it will not work without matching
keys.