[mythtv-users] mysql setup on 'new' backend machine

[Kirby Bakken]

I'm having trouble accessing MySql on my 'new' backend machine.  I've 
followed the instructions and setup the mythdatabase:

mysql < /usr/share/mythtv/database/mc.sql  (running gentoo)

granted access on the same subnet:

$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";
mysql> flush privileges;

on the backend machine I can do this:

mysql -u mysql

but I can't do this:

mysql -u mysql -h 192.168.1.8  (the machine tcp address is static and set to that)

so, obviously if I can't access the db using the host address on the same machine, I can't access it from my frontend....  what am I doing wrong?

(I've also checked to make sure that /etc/mysql/my.cnf has 'skip-networking' commented out)


------------------------------------------------------------------------