default_password_lifetime
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:
Overview
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.
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES
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 noPASSWORD 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 thePASSWORD 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 anyPASSWORD EXPIRE ...
clause other than thePASSWORD 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 | Multi-Node Analytics | 10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) |
Single Node Analytics | 10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
Distributed Transactions | 10.5 | Not present | |
10.6 | Not present | ||
Replicated Transactions | 10.4 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
10.6 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
Single Node Transactions | 10.4 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
10.6 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
GCP | Multi-Node Analytics | 10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) |
Single Node Analytics | 10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
Distributed Transactions | 10.5 | Not present | |
10.6 | Not present | ||
Replicated Transactions | 10.4 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
10.6 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
Single Node Transactions | 10.4 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | |
10.5 | 0 (choices: 0, 7, 14, 30, 90, 180, 365) | ||
10.6 | 0 (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 |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
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.