simple_password_check_digits

Overview

Minimal required number of digits

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

USAGE

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

DETAILS

The simple_password_check_digits system variable is one of the system variables that controls how the simple_password_check plugin validates new passwords:

  • If a user tries to create a user account with the CREATE USER or GRANT statements and the password has fewer digit characters than the configured value, then the password will be rejected, and the user account will not be created.

  • If a user tries to set a user account password with the SET PASSWORD, ALTER USER, or GRANT statements and the password has fewer digit characters than the configured value, then the password will be rejected, and the user account password will not be changed.

  • A digit character is any character in the range 0-9.

PARAMETERS

Dynamic

Yes

Scope

Global

Data Type

INT UNSIGNED

Minimum Value

0

Maximum Value

1000

Default Value

1

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

Multi-Node Analytics

10.6

1 (choices: 0, 1, 2, 5, 10)

Single Node Analytics

10.6

1 (choices: 0, 1, 2, 5, 10)

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

1 (choices: 0, 1, 2, 5, 10)

10.5

1 (choices: 0, 1, 2, 5, 10)

10.6

1 (choices: 0, 1, 2, 5, 10)

Single Node Transactions

10.4

1 (choices: 0, 1, 2, 5, 10)

10.5

1 (choices: 0, 1, 2, 5, 10)

10.6

1 (choices: 0, 1, 2, 5, 10)

GCP

Multi-Node Analytics

10.6

1 (choices: 0, 1, 2, 5, 10)

Single Node Analytics

10.6

1 (choices: 0, 1, 2, 5, 10)

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

1 (choices: 0, 1, 2, 5, 10)

10.5

1 (choices: 0, 1, 2, 5, 10)

10.6

1 (choices: 0, 1, 2, 5, 10)

Single Node Transactions

10.4

1 (choices: 0, 1, 2, 5, 10)

10.5

1 (choices: 0, 1, 2, 5, 10)

10.6

1 (choices: 0, 1, 2, 5, 10)

PRIVILEGES

The simple_password_check_digits 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