[mythtv-users] database access

[Per Jørgensen]

Henrik Beckman wrote:
> snip
>   
>>> mysql> SELECT `Host`,`User`,`Password` FROM `user` WHERE `User` = 'mythtv';
>>>
>>> Check to see if the password hashes are the same for all occurences of
>>> the mythtv user, and that you have any entry for localhost.
>>>       
>> mysql> select `Host`,`User`,`Password` from `user` WHERE `User` = 'mythtv';
>> +---------------+--------+-------------------------------------------+
>> | Host          | User   | Password                                  |
>> +---------------+--------+-------------------------------------------+
>> | localhost     | mythtv | *07B8126C2DD7B5C86540517EEC78CC3AC92C9FA8 |
>> | %             | mythtv | *07B8126C2DD7B5C86540517EEC78CC3AC92C9FA8 |
>> | 192.168.1.% | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
>> +---------------+--------+-------------------------------------------+
>>     
>
> snip
>
>   
>> So everything worked which is good. So I added the host 192.168.1.%
>> back - this time with the correct password and everything still works.
>> Which leads me to the question, how do I get rid of the '%' host for
>> mythtv? If I do "drop user 'mythtv'@'%';" won't I loose all of the
>> hosts including localhost and 192.168.1.% since the '%' is a wildcard?
>> Or in this case am I specifying host equal to '%' where this time '%'
>> is understood as char and not the wildcard? Anyway, would rather not
>> wipe out my database ;)
>>
>> --
>> ~pAul.
>>     
>
> I can´t get mythweb to work and for me % is the problem,
> mysql> select `Host`,`User`,`Password` from `user` WHERE `User` = 'mythtv';
> +-------------+--------+-------------------------------------------+
> | Host        | User   | Password                                  |
> +-------------+--------+-------------------------------------------+
> | localhost   | mythtv | ok |
> | %           | mythtv | wrong |
> | 192.168.1.% | mythtv | ok |
> | 192.168.0.% | mythtv | ok |
> +-------------+--------+-------------------------------------------+
> 4 rows in set (0.00 sec)
>
> % mythtv has the wrong password =(
>
> /Henrik
>   
You can either use the webinterface from webmin or anything like it to 
set the passwd again.
Otherwise you can use the command - UPDATE from commandline.
Something like UPDATE TABLE USER SET PASSWORD="New passwd" WHERE Host="%";

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090308/063aec34/attachment.htm>