[mythtvnz] Frontend on another computer

[Robert Fisher]

On Thu, 12 Jan 2006 5:10 pm, Wade Maxfield wrote:
> >On Thu, 12 Jan 2006 4:52 pm, Wade Maxfield wrote:
> >>  >I am trying to set up a mythfrontend on my PC but cannot connect to
> >>  > the database.
> >>  >
> >>  >I have run (on the backend)
> >>  >
> >>  >mysql -u root -p mythconverg
> >>  >
> >>  >grant all on mythconverg.* to mythtv@"192.168.10.%" identified by
> >>  > "mythtv"; flush privileges;
> >>  >
> >>  >but when I run "mythfrontend"
> >>  >it goes through the setup screens then goes back to my command screen.
> >>  >
> >>  >should I use something like
> >>  >grant all on mythconverg.* to robert@"192.168.10.%" identified by
> >>  > "robert";
> >>  >
> >>  >or (because our MythTV box is set to log in as root)
> >>  >grant all on mythconverg.* to root@"192.168.10.%" identified by
> >>  > "root";
> >>  >
> >>  >Any ideas?
> >>  >
> >>  >--
> >>  >Regards, Robert
> >>
> >>  Is there a firewall running on the mysql box?  Port 3306 needs to be
> >>  open if it is.
> >
> >No, there is no firewall running.
> >
> >>  What happens if you try "mysql -h hostipaddress -u username -p
> >>  mythconverg"  from the new frontend?
> >
> >mysql -h 192.168.10.27 -u root -p
> >gives
> >ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.27' (111)
>
> That looks similar to the error I get when I try to connect to a
> machine that has no MySQL running on it.

It must be running though as the frontend works on that machine.
>
> What's the IP address of the backend?
192.168.10.27
> And what's the IP address of 
> the new frontend?
192.168.10.3
>