default_password_lifetime

This defines the global password expiration policy. 0 means automatic password expiration is disabled. If the value is a positive integer N, the passwords must be changed every N days. This behavior can be overridden using the password expiration options in ALTER USER.

This page is part of MariaDB's SkySQL Documentation.

The parent of this page is: System Variables for MariaDB Enterprise Server

Topics on this page:

USAGE
DETAILS
CHANGE HISTORY
EXTERNAL REFERENCES

USAGE

The default_password_lifetime system variable can have its default value configured via SkySQL Configuration Manager.

DETAILS

The default_password_lifetime system variable defines the number of days that are required between password changes by default.

If the default_password_lifetime system variable is set to 0, then passwords do not expire by default.
The default_password_lifetime system variable will be used for a given user account if the user account was created or altered with no PASSWORD EXPIRE ... clause.
The default_password_lifetime system variable will also be used for a given user account if the user account was created or altered with the PASSWORD EXPIRE DEFAULT clause.
The default_password_lifetime system variable will be ignored for a given user account if the user account was created or altered with any PASSWORD EXPIRE ... clause other than the PASSWORD EXPIRE DEFAULT clause.

PARAMETERS

Dynamic	Yes
Scope	Global
Data Type	INT UNSIGNED
Minimum Value	0
Maximum Value	4294967295
Default Value	0

SKYSQL

Cloud	SkySQL Topology	ES Ver	Default
AWS	HA (Primary/Replica)	10.4	0 (choices: 0, 7, 14, 30, 90, 180, 365)
AWS	HA (Primary/Replica)	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
AWS	Transactional Standalone	10.4	0 (choices: 0, 7, 14, 30, 90, 180, 365)
AWS	Transactional Standalone	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
AWS	Distributed Transactions	10.5	Not present (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	ColumnStore	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	ColumnStore Multi	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	Galera	10.4	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	Galera	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	HA (Primary/Replica)	10.4	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	HA (Primary/Replica)	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	HTAP	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	Transactional Standalone	10.4	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	Transactional Standalone	10.5	0 (choices: 0, 7, 14, 30, 90, 180, 365)
GCP	Distributed Transactions	10.5	Not present (choices: 0, 7, 14, 30, 90, 180, 365)

PRIVILEGES

The default_password_lifetime system variable requires the SUPER privilege to dynamically set its value at runtime.

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES

This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the default_password_lifetime page in the MariaDB Enterprise Documentation.