MySQL8.0でのパスワードポリシー

MySQL8.0でのパスワードポリシー

8.0に上げたらパスワードポリシーがちょいと厳しくなったようで。
mysql_secure_installationというツールで調整できるみたいですが、一番低いLOWにしても、最低8文字必要みたい。

# mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No:

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: