[mythtv-users] Mythfrontend doesn't update database to new schema

[James Pifer]

On Tue, 2011-08-02 at 12:59 -0400, James Pifer wrote:
> 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.
> 

I was able to get it cleaned up and the frontend loads now. 

Thanks,
James