[mythtvnz] Broken communication from front end

Tony Sauri hoiho.nz at gmail.com
Thu Sep 20 10:47:29 BST 2012


On 20/09/12 21:08, Worik Stanton wrote:
> On 20/09/12 20:59, Tony Sauri wrote:
>>      select Host, DB, User from db where Db = "mythconverg";
> mysql> select Host, DB, User from db where Db = "mythconverg";
> +-------------+-------------+--------+
> | Host        | DB          | User   |
> +-------------+-------------+--------+
> | %           | mythconverg | mythtv |
> | 192.168.1.% | mythconverg | mythtv |
> | localhost   | mythconverg | mythtv |
> +-------------+-------------+--------+
> 3 rows in set (0.00 sec)
>
>
>



Ok

If you issue the following SQL statemnts (logged in as root you will 
undo the  effects of your "Grant" statement

use mysql;

DELETE FROM  db WHERE Host LIKE "192.168.1.%" AND DB = "mythconverg" AND 
User = "mythtv";

DELETE FROM user WHERE Host LIKE "192.168.1.%" AND User = "mythtv" ;

Regards


TOny Sauri






More information about the mythtvnz mailing list