[mythtv-users] Messed up DB connection!

David Campbell dave at cpfc.org
Mon Jan 22 19:01:24 UTC 2007


John Pierce wrote:
> Calling all gurus.
> 
> I have been running a local network at home for a long time.  I had
> myth setup so that any machine on my local network could connect.  I
> did this so I could be anywhere in the house and schedule recordings,
> etc.  My home network had always been on 192.168.0.0/24 as that was
> the default network in my router, gateway being 192.168.0.1.
> 
> However, lately I have been using my notebook at work and their
> default network is 192.168.1.0/24, so I have reconfigured my home
> network to the 192.168.1.0/24 so that it would be easier to connect
> the their network.

Isn't this what dhpd is for ;)
> 
> I have reconfigured my broadband router, local dns servers, and all
> machines on the network.  From my masterbackend I can connect locally
> via that machine, but now none of my remote machines can connect.  The
> following error is what I get from a command line if I run
> mythfrontend:
> 
> Database error was:
> Host '192.168.1.60' is not allowed to connect to this MySQL server

In mysql the syntax would be

grant all on mythconverg.* to mythtv at 192.168.1.60;

Dave




More information about the mythtv-users mailing list