[mythtv-users] mysql issue when accessing backend from a remote frontend

[Andy Barr]

Previously I had MythTv setup on Fedora 4 and used a XBOX as my
frontend.  Now I am switching to Ubuntu on my backend.  MythTV
frontend and backend are working on my Ubuntu machine.  However when I
try to run mythfrontend on my xbox I get an error about not being able
to connect to the database.  This is my error,

2006-08-19 15:37:52.089 Using runtime prefix = /usr
2006-08-19 15:37:53.505 New DB connection, total: 1
2006-08-19 15:37:53.523 Unable to connect to database!
2006-08-19 15:37:53.523 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'xbox' (using password: YES)

I spent many hours researching the issue and ran these commands on my backend,

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

I even tried this,

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

I also edited my /etc/mysql/my.cnf file and commented out this line,
# bind-address          = 127.0.0.1

If I try this on my xbox,
xbox:/# mysql -u mythtv -p -h 192.168.2.253
Enter password:
ERROR 1045: Access denied for user 'mythtv'@'xbox' (using password: YES)

If anyone has a suggestion on how to solve this issue please let me know.

Thanks,
Andy