[mythtv-users] Debian update fails mythtv-database (re)configure

[A. F. Cano]

On Tue, Jul 21, 2015 at 10:22:06PM +1200, Robin Gilks wrote:
> 
> > On 07/04/2015 08:28 PM, Robin Gilks wrote:
> >...
> Another couple of weeks and I've still not solved it.
> 
> All the passwords etc match up so no idea where it fails.
> 
> How can I just blat the configure stage right out of the way - ignore it,
> delete it or whatever, just to shut the stupid thing up?

I've been meaning to reply earlier but never got around to do it.
I sometimes encounter this problem (or a similar one) after an upgrade.
Something changes and the database becomes inaccessible.  I have solved
it by doing this:

> mysql -u root -p mysql
Enter password: <my mysqul root password>
mysql> grant all privileges on mythconverg.* to 'mythtv'@'localhost'
identified by 'mythtv' with grant option;
mysql> grant all privileges on mythconverg.* to 'mythtv'@'%' identified
by 'mythtv' with grant option;
mysql> flush privileges;
mysql> quit


I run myth as myself, not root, so I had to do this the first time after
installation:

adduser afc mythtv

I hope this helps.  I would like to know why this is necessary after
some upgrades.  I use the packages from deb-multimedia.org

Of course, this is not really the correct fix.  It shouldn't be
necessary to do this manually after upgrading.

Augustine