Information
Require the current password for password reset.
Rationale:
Requiring a prior password for password reset enables DBAs to prevent users from changing a password without proving that they know the current password. Such changes could otherwise occur, for example, if one user walks away from a terminal session temporarily without logging out, and a malicious user uses the session to change the original user's MySQL password. This can have unfortunate consequences; the most problematic being the malicious user can access MySQL with the user's changed credentials.
Solution
Set the value to ON
SET PERSIST password_require_current=ON;
Default Value:
The password_require_current is OFF by default.