[mythtv-users] database access

[Henrik Beckman]

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