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

[James Abernathy]

On Tue, Jan 25, 2022 at 7:40 PM Hika van den Hoven <hikavdh at gmail.com>
wrote:

> 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
>

Thanks, that explains it. I just assumed the database backup would include
the password.  It was behaving like it didn't.  So my new hardware database
password was supplied when I installed mythtv on the new hardware and
that's the password I should have been using.

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220125/3739fd34/attachment.htm>