[mythtv-users] Messed up DB connection!
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
> 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;
More information about the mythtv-users