方法一：寫入配置文件，重啟MySQL實例[mysqld]plugin-load=validate_password.so
方法二：在實例運行中使用install plugin命令加載插件INSTALL PLUGIN validate_password SONAME 'validate_password.so';二、驗證插件加載情況
mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS    -> WHERE PLUGIN_NAME LIKE 'validate%';+-------------------+--------------------+| PLUGIN_NAME       | PLUGIN_STATUS      |+-------------------+--------------------+| validate_password | ACTIVE             |+-------------------+--------------------+1 row in set (0.00 sec)三、查看默認密碼策略默認的密碼強度級別是中等（MEDIUM），即密碼不能少于8位，且要包含數字、大小寫字母、特殊符號至少各一個：
mysql> show variables like '%validate_password%';+--------------------------------------+--------+| Variable_name                        | Value  |+--------------------------------------+--------+| validate_password_check_user_name    | OFF    |             #設為 ON 時密碼中不允許包含用戶名| validate_password_dictionary_file    |        |             #用于密碼驗證的字典文件路徑，僅在密碼驗證級別為STRONG時生效| validate_password_length             | 8      |             #限制密碼最短長度不得少于8位| validate_password_mixed_case_count   | 1      |             #密碼中大小寫字母的最少個數| validate_password_number_count       | 1      |             #密碼中數字的最少個數| validate_password_policy             | MEDIUM |             #設置密碼驗證級別| validate_password_special_char_count | 1      |             #密碼中特殊符號的最少個數+--------------------------------------+--------+四、測試密碼插件的效果在新設置不符合密碼策略規則的密碼時會報錯，提示不滿足密碼策略要求：
mysql> create user hy@'192.168.1.%' identified by 'xxxxxx123';ERROR 1819 (HY000): Your password does not satisfy the current policy requirements設置符合策略的復雜密碼后可以成功執行：
mysql> create user hy@'192.168.1.%' identified by '1qaz@WSX';Query OK, 0 rows affected (0.00 sec)mysql> select user,host,authentication_string from mysql.user;+-----------+-------------+-----------------------------------------------------------+| user      | host        | authentication_string                                     |+-----------+-------------+-----------------------------------------------------------+| root      | localhost   | *6AF239DABA5FB2A794AFA158646426FC1E9A5742                 || mysql.sys | localhost   | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE                 || hy        | 192.168.1.% | *58319282EAB9E38D49CA25844B73DA62C80C2ABC                 |+-----------+-------------+-----------------------------------------------------------+