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

[Andy Barr]

On 8/19/06, William <wmunson at rochester.rr.com> 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;
> >
>
> It sounds like you are not running the mysql server. Its disabled by default
> in the newer systems.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Thanks for the suggestions.  I still cannot get it to work.  I can
connect to mysql from my backend machine so I assume mysql server is
running.  I see mysqld listed as a process that is running from a ps
-ef command.

I don't have /etc/sysconfig/mysqld on my Ubuntu system.  I edited this file,
/etc/mysql/my.conf and I don't have any -skip-networking option listed
in this file.  I also commented out this line # bind-address

This command works on my backend machine,
mysql -u mythtv -p -h 192.168.2.253

Here is some more output that might help.

andy at mythtv:~$ mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.22-Debian_0ubuntu6.06-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select host, user, password from user;
+--------------+------------------+------------------+
| host         | user             | password         |
+--------------+------------------+------------------+
| localhost    | root             | 121900c5120ed8d8 |
| mythtv       | root             |                  |
| localhost    | debian-sys-maint | 417a15742dd5e8e5 |
| localhost    | mythtv           | 0476fc026afffe24 |
| %            | mythtv           | 0476fc026afffe24 |
| 192.168.2.%% | mythtv           | 0476fc026afffe24 |
| 192.168.2.50 | mythtv           | 67457e226a1a15bd |
| 192.168.2.%  | mythtv           | 0476fc026afffe24 |
| xbox         | mythtv           | 0476fc026afffe24 |
+--------------+------------------+------------------+
9 rows in set (0.00 sec)

I suspect this is some mysql configuration issue but I searched and
tried every suggestion I saw.  Does anyone have any more ideas?
Thanks,
Andy