[mythtv-users] mysql issue when accessing backend from a remotefrontend
wmunson at rochester.rr.com
Sat Aug 19 22:28:42 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;
It sounds like you are not running the mysql server. Its disabled by default
in the newer systems.
More information about the mythtv-users