An admin can open Settings → Household members and tap the key icon next to your name. That creates a one-time link, good for 24 hours, where you can choose a new password.
If you set up a passkey, you can still sign in with your passkey without your password.
Locked-out admin? Whoever runs the server can make a link with npm run reset-password -- <username>.