max_password_errors
- In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS:
If there is more than this number of failed connect attempts due to invalid password, user will be blocked from further connections until FLUSH_PRIVILEGES.
- In 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
PARAMETERS
Command-line |
--max_password_errors=# |
Configuration file |
Supported |
Dynamic |
Yes |
Scope |
Global |
Data Type |
INT UNSIGNED |
Minimum Value |
1 |
Maximum Value |
4294967295 |
Default Value |
4294967295 |
SKYSQL
Cloud |
SkySQL Topology |
ES Ver |
Default |
---|---|---|---|
AWS |
HA (Primary/Replica) |
10.4 |
4294967295 |
AWS |
HA (Primary/Replica) |
10.5 |
4294967295 |
AWS |
Transactional Standalone |
10.4 |
4294967295 |
AWS |
Transactional Standalone |
10.5 |
4294967295 |
AWS |
Distributed Transactions |
10.5 |
4294967295 |
GCP |
ColumnStore |
10.5 |
4294967295 |
GCP |
ColumnStore Multi |
10.5 |
4294967295 |
GCP |
Galera |
10.4 |
4294967295 |
GCP |
Galera |
10.5 |
4294967295 |
GCP |
HA (Primary/Replica) |
10.4 |
4294967295 |
GCP |
HA (Primary/Replica) |
10.5 |
4294967295 |
GCP |
HTAP |
10.5 |
4294967295 |
GCP |
Transactional Standalone |
10.4 |
4294967295 |
GCP |
Transactional Standalone |
10.5 |
4294967295 |
GCP |
Distributed Transactions |
10.5 |
4294967295 |
See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.
CHANGE HISTORY
Release Series |
History |
---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the max_password_errors page in the SkySQL Documentation.