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

[Andy Barr]

On 8/19/06, William Munson <wmunson at rochester.rr.com> wrote:
> >
> > 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
> >
>
> This may seem a bit obvious, is your network on 192.168.2.%?  Most are
> on .1.%
>
> Another option would be to install webmin and use it to configure mysql
> in a nice gui. You should be able to verify if the server is working. by
> telneting to your backend on the mysql port from your remote machine and
> see what your login attempt does.
>

Yes my network is 192.168.2.%.

I installed webmin and as best I can tell permissions are correct.
Under user permissions it says,
mythtv 192.168.2.% permissions=All
Under database permissions it says the same thing with database of mythconverg.
Nothing is listed under Host permissions.  Is that correct?

This is what I get from telnetting.

xbox:~/.ssh# telnet 192.168.2.253 3306
Trying 192.168.2.253...
Connected to 192.168.2.253.
Escape character is '^]'.
G
5.0.22-Debian_0ubuntu6.06'a6*j]p<wfvA"$/\bXt^
Connection closed by foreign host.

Thanks for the help.
Andy