MySQL 8 密码复杂度策略 validate_password

查看已安装的MySQL插件

查看有无安装validate_password插件

mysql> show plugins;
+---------------------------------+----------+--------------------+-----------------------+---------+
| Name                            | Status   | Type               | Library               | License |
+---------------------------------+----------+--------------------+-----------------------+---------+
| binlog                          | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| mysql_native_password           | ACTIVE   | AUTHENTICATION     | NULL                  | GPL     |
| sha256_password                 | ACTIVE   | AUTHENTICATION     | NULL                  | GPL     |
| caching_sha2_password           | ACTIVE   | AUTHENTICATION     | NULL                  | GPL     |
| sha2_cache_cleaner              | ACTIVE   | AUDIT              | NULL                  | GPL     |
| CSV                             | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| MEMORY                          | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| InnoDB                          | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| INNODB_TRX                      | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMP                      | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMP_RESET                | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMPMEM                   | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMPMEM_RESET             | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMP_PER_INDEX            | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CMP_PER_INDEX_RESET      | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_BUFFER_PAGE              | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_BUFFER_PAGE_LRU          | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_BUFFER_POOL_STATS        | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_TEMP_TABLE_INFO          | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_METRICS                  | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_DEFAULT_STOPWORD      | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_DELETED               | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_BEING_DELETED         | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_CONFIG                | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_INDEX_CACHE           | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_FT_INDEX_TABLE           | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_TABLES                   | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_TABLESTATS               | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_INDEXES                  | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_TABLESPACES              | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_COLUMNS                  | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_VIRTUAL                  | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_CACHED_INDEXES           | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| INNODB_SESSION_TEMP_TABLESPACES | ACTIVE   | INFORMATION SCHEMA | NULL                  | GPL     |
| MyISAM                          | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| MRG_MYISAM                      | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| PERFORMANCE_SCHEMA              | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| TempTable                       | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| ARCHIVE                         | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| BLACKHOLE                       | ACTIVE   | STORAGE ENGINE     | NULL                  | GPL     |
| FEDERATED                       | DISABLED | STORAGE ENGINE     | NULL                  | GPL     |
| ngram                           | ACTIVE   | FTPARSER           | NULL                  | GPL     |
| mysqlx_cache_cleaner            | ACTIVE   | AUDIT              | NULL                  | GPL     |
| mysqlx                          | ACTIVE   | DAEMON             | NULL                  | GPL     |
| validate_password               | ACTIVE   | VALIDATE PASSWORD  | validate_password.dll | GPL     |
+---------------------------------+----------+--------------------+-----------------------+---------+
45 rows in set (2.20 sec)

安装validate_password插件

查看插件目录

mysql> show variables like '%plugin_dir%';
+---------------+--------------------------------------------+
| Variable_name | Value                                      |
+---------------+--------------------------------------------+
| plugin_dir    | E:\Install\mysql-8.0.20-winx64\lib\plugin\ |
+---------------+--------------------------------------------+
1 row in set, 1 warning (0.01 sec)

确保插件目录中有validate_password的插件

安装插件

mysql> install plugin validate_password soname 'validate_password.dll';
Query OK, 0 rows affected, 1 warning (0.07 sec)

查看安装结果

mysql> show variables like '%validate%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | ON     |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set, 1 warning (0.00 sec)

官方文档：
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html