I recently decided to reinstall my Mythbuntu system, as it had been upgraded in phases from version 10.x and was throwing up fairly frequent errors.
The situation as was: Mythbuntu 12.something, running MythTV 0.26. Recordings are stored on a different drive to everything else, including the database.
How I proceeded:
Used the Mythbuntu Control Centre's builtin Backup command to back up settings and database to the recordings drive.
Reinstalled Mythbuntu from an up to date ISO, wiping the system drive in the process.
Updated to MythTV 0.26 using the Mythbuntu repo.
Edited fstab to mount the recordings drive in the appropriate place.
Used the Mythbuntu Control Centre's builtin Restore command to restore the database and settings.
The problem: Now mythfrontend insists that it can't find the database. My guess is that one of the things that was backed up and restored was the mysql password for the database - but presumably on a new install this is different to the old install?
How can I find out the correct password? Or, am I barking totally up the wrong tree here? Thanks :) I'm afraid my knowledge of mysql admin is rather limited.