Sets the minimum length for new passwords in the database.
The value is in bytes. For single-byte character sets, this is the same as the number of characters.
Can only be set for the PUBLIC group. Takes effect immediately. DBA permissions are required to set this option.
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;