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

[Michael T. Dean]

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