[mythtv-users] database access

Henrik Beckman henrik.list at gmail.com
Sun Mar 8 10:29:10 UTC 2009


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


More information about the mythtv-users mailing list