min_password_length option

Sets the minimum length for new passwords in the database.

Allowed values

Integer

The value is in bytes. For single-byte character sets, this value is the same as the number of characters.

Default

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY SECURITY OPTION	No	No
Allowed to set temporarily?	Yes, with SET ANY SECURITY OPTION	No	No

Remarks

This option allows the database administrator to impose a minimum length on all new passwords for greater security. Existing passwords are not affected. Passwords have a maximum length of 255 bytes and are case sensitive.

Example

Set the minimum length for new passwords to 6 bytes.

SET OPTION PUBLIC.min_password_length = 6;