My Oracle Support Banner

Password Change Enforcement, Expiry and Quality Assurance On MySQL Server (Doc ID 1432824.1)

Last updated on FEBRUARY 27, 2020

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Goal

How can we implement advanced password management functionality within MySQL?

Functionality that is needed includes:
  • Password change enforcement upon first login. (Implemented now)
  • Password expiry after certain period, for example, 90 days. (Implemented in 5.7)
  • Password should contain minimum length of characters and should have both numeric and alphabetic.(Implemented in 5.6 using password validation plugin)
  • Password should not reuse recent passwords (Implemented in 8.0 in the history and reuse syntax in CREATE USER)


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Version 4.x
 5.0 and 5.1 Versions
 5.5 and 5.6 Versions
 Version 5.7
 Version 8.0
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.