MySQL Security – Dual Password Support
May 19, 2020
MySQL 8.0 has introduced an optional behavior that authorize users to change their password only if they could provide the current password.
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password.
MySQL has the capability of generating random passwords for user accounts, as an alternative to requiring explicit administrator-specified literal passwords.