[mythtvnz] Frontend on another computer

[Robert Fisher]

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)