[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