Account password rotation is often a regulatory requirement. For that very reason, MySQL allows you to have multiple passwords on a single account. I have written about this in Rotating Accounts...

Last October, we introduced a new identity model on iOS (Chrome 118) and are excited to bring it to Android devices and Desktop soon. This model aligns closely with how you already use other...

When implementing user authentication with passwords throw out the password rules you know.