[mythtv-users] Mythfrontend doesn't update database to new schema
James Pifer
jep at obrien-pifer.com
Tue Aug 2 16:59:04 UTC 2011
On Tue, 2011-08-02 at 12:49 -0400, Michael T. Dean wrote:
> On 08/02/2011 12:19 PM, James Pifer wrote:
> > On Tue, 2011-08-02 at 17:03 +0100, David Watkins wrote:
> >>> If I look at mysql.users there are multiple rows for mythtv, so I'm not
> >>> sure if that confirms I'm not shadowing?
> >> what does
> >>
> >> mysql> select host,user,password from mysql.user;
> >>
> >> give?
> > MariaDB [mysql]> select host,user,password from mysql.user;
> > +---------------------------+--------+-------------------------------------------+
> > | host | user | password |
> > +---------------------------+--------+-------------------------------------------+
> > | localhost | root | *BBFDF174BC011F4BA56B355094446E5D65E9B471 |
> > | mythtv | root | *BBFDF174BC011F4BA56B355094446E5D65E9B471 |
> > | 127.0.0.1 | root | *BBFDF174BC011F4BA56B355094446E5D65E9B471 |
> > | localhost | | |
> > | mythtv | | |
> > | localhost | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
> > | 192.168.1.0 | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
> > | 192.168.1.0/255.255.255.0 | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
> > | 192.168.1.% | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
> > +---------------------------+--------+-------------------------------------------+
> > 9 rows in set (0.00 sec)
>
> What happens if you get rid of the anonymous users:
>
> mysql -uroot -p mysql -e 'DELETE FROM user WHERE user = "" OR user IS
> NULL; FLUSH PRIVILEGES;'
>
> Mike
Unfortunately no change when running the frontend.
Thanks,
James
More information about the mythtv-users
mailing list