Sets the minimum length for new passwords in the database.
Integer
The value is in bytes. For single-byte character sets, this is the same as the number of characters.
0 characters
Can only be set for the PUBLIC group. Takes effect immediately. DBA authority required.
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.
Set the minimum length for new passwords to 6 bytes.
SET OPTION PUBLIC.min_password_length = 6;