[mythtv-users] mysql issue when accessing backend from a remote frontend
Andy Barr
ajbarr at gmail.com
Sat Aug 19 19:54:24 UTC 2006
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
More information about the mythtv-users
mailing list