[mythtv-users] database access

[Henrik Beckman]

On Sun, Mar 8, 2009 at 2:56 PM, Henrik Beckman <henrik.list at gmail.com> wrote:
> snip
>>
>>
>> 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
>>
>
>> 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="%";
>>
>
> Thanks,
>
> This worked for me,
>  SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('yourpasswordhere');
>
> It only affects the % line not the others.
>
> Mysql manual says, http://dev.mysql.com/doc/refman/5.0/en/set-password.html
>
> Still no mythweb though.. =(
>
> /Henrik
>

Works now, did an apt-get purge and reinstalled mythweb, corrected
usrname/password and hostname in mythweb.conf.

/Henrik