2.7 Ensure 'password_lifetime' is Less Than or Equal to '365'

Information

Password expiration provides users with a unique time bounded password lifetime.

Allows additional security factors pertinent to a specific user to provide further password security; predetermined by varying security needs and usability requirements in a system or organization.

Solution

To configure the global password lifetime to 365 by executing the following command:

set persist default_password_lifetime = 365;

Alternatively, configure the password lifetime for each user returned by the audit procedure by executing the following command:

ALTER USER '<username>'@'<localhost>' PASSWORD EXPIRE INTERVAL 365 DAY;

See Also

https://workbench.cisecurity.org/benchmarks/20915

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-5(1)(d)

Plugin: MySQLDB

Control ID: 096a503b231d243ec8000ec5f9e12876ab84828fcc1cf10bfb9fa76a27e05ee6