[mythtvnz] Frontend on another computer

[Wade Maxfield]

>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.

What's the IP address of the backend?  And what's the IP address of 
the new frontend?

  - Wade