[mythtv-users] what is my database password after restore?

[Hika van den Hoven]

Hoi James,

Wednesday, January 26, 2022, 12:07:55 AM, you wrote:

> I'm testing how I'm going to migrate my backend to new hardware so
> I'll not screw it up when it's time to do it for real.


> I built up the new hardware and got the mythtv frontend and backend working with HDHR tuners.


> Next  copied over all my recordings from my production backend to
> the new hardware. Then I took a database backup and restored it
> using the --drop_database and --create_database options. 


> With the backend stopped for all this I went in with mythtv-setup
> and changed tuners, Video sources, connections, and Storage groups
> locations. So I had it working as a combo and ran into problems with
> remote front ends like FireTV 4k android mythfrontend. 


> I found the file with the bind_address=:: needed to be moved to
> mariadb.conf.d because of the search order. That allowed the FireTV
> to connect using the UPNP search. 


> But the mythconverg passwords that ended up in all my config.xml
> files was the password from the new hardware mythtv prior to
> restoring the database from the production backend.


> So the $64,000 question is after a restore of the database, what is
> the password? the one from the restore file, or the one already in the database?


> From what I see my old production database, where I got the backup
> file to restore on the new hardware is NOT the same database
> password that the new hardware is using after the restore.


> If I can't figure this out, what is the process to change the new
> hardware database password to something I can be sure of lik 'mythtv'


> Jim A

The mythtv account/password is NOT part of a backup! It's part of
your mySQL/MariaDB installation.

So if you setup a mythtv account and password in your new installation
it's that. If you haven't you will still have to do that as then there
not yet is a mythtv account in the database. How to do that you can
find in the WIKI.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens