[mythtv-users] Fixing minor errors in Myth database

[Michael T. Dean]

On 04/28/2013 11:36 PM, Fred Hamilton wrote:
> Quick update in case it helps anyone:  I found that mythbackend wasn't 
> launching at boot (or after running mythtv-setup) because I had 
> changed the mythtv database password to "mythtv" from the 
> "dtageld5"-like password my system originally had.
>
> I had changed the password for mythconverg in:
>  - the mysql database,
>  - /etc/apache2/sites-available/mythweb.conf
>  - mythtv-setup
>  - mythtv/mysql.txt
>
> And if I manually launched mythbackend everything worked fine.  But I 
> could not get it to go back to launching at startup until I changed 
> the password back to the one I was using before the --partial_restore...

Yeah, the different distros try to make it easy for you by hiding the 
details of the MySQL password, but in so doing make it very difficult 
(or downright wrong?) to change the MySQL password without using the 
tools they provide to do so (like some kind of apt something reconfigure 
type black magic  or something ;).  That's why I suggested the 
drop/create without any GRANT (and why I put the line in the HOWTO that 
warns about messing with the password).

There was likely a $HOME/.mythtv/config.xml (we don't use mysql.txt 
anymore) that was being used in the environment of the startup script 
that differed from the one being used when you manually started one.

Mike