Using backup application database with a new user

you can try this: https://www.metabase.com/docs/latest/administration-guide/04-managing-users.html#resetting-the-admin-password