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

[Chuck Filson]

On Saturday 19 August 2006 03:54 pm, Andy Barr wrote:
> 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.
>

Did you remember to remove the "--skip-networking" option 
in /etc/sysconfig/mysqld ( Fedora path may not be the same ) ?

Chuck