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

[William Munson]

>
> 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.