[mythtv-users] database access
Henrik Beckman
henrik.list at gmail.com
Sun Mar 8 13:56:03 UTC 2009
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
More information about the mythtv-users
mailing list