[mythtv-users] can't get into mythweb

[Steve Peters - Priority Electronics]

>>>>> Lastly, if someone is bold enough, I would be more than 
>>>>willing to give you
>>>>> ssh root access into my box. I'll only give it to someone 
>>>>whom I've seen do
>>>>> many posts on the myth list, and not a first time poster. 
>>>>Ya ya, don't do
>>>>> that cause it's not a good idea, but I trust the myth 
>>>>community, plus, there
>>>>> is nothing important on the computer other than tv recordings.
>>>>> 
>>>>> -Thanks for the help (and patience with me). I'm sure it's 
>>>>something stupid
>>>>> and simple that I've missed, but I seriously hope it's 
>>>>something that is
>>>>> more complex (for the sake of my pride).
>>>>> -Steve


Here's what I got from Nick Morrott who kindly fixed my system:

Delete blanket wildcard entries:

    mysql> DELETE FROM user WHERE Host = '%';

Delete erroneous Host entries for LAN:

    mysql> DELETE FROM user WHERE Host LIKE '192%';

Grant permission for user 'mythtv' on 192.168.1/24 network

    mysql> grant all on mythconverg.* to mythtv@"192.168.1.%"
identified by "mythtv";

Grant permission for user 'mythtv' on host 'mythtv-server'

    mysql> grant all on mythconverg.* to mythtv@"mythtv-server"
identified by "mythtv";

Flush the changes through, and quit

    mysql> flush privileges;


Restart mysql and apache, and now it works.
-Thanks to all who contributed. This mysql stuff is somewhat out of my reach
at the moment as I've never really delved into it.
-Steve