Start MySQL Password audit plugin

Http://www.innomysql.com/article/25717.html

[[email protected] plugin]# pwd/Usr/Local/Mysql56/Lib/plugin[[email protected] plugin]# Lltotal2184-Rwxr-xr-X.1Root MySQL15437Sep +   -adt_null.so-Rwxr-xr-X.1Root MySQL25619Sep +   -auth.so-Rwxr-xr-X.1Root MySQL12364Sep +   -auth_socket.so-Rwxr-xr-X.1Root MySQL25072Sep +   -auth_test_plugin.so-rw-R--r--. 1 root mysql 227 Sep daemon_example.iniDrwxr-xr-X.2Root MySQL4096 Dec  One   -Debug-Rwxr-xr-X.1Root MySQL573478Sep +   -innodb_engine.so-Rwxr-xr-X.1Root MySQL42321Sep +   -libdaemon_example.so-Rwxr-xr-X.1Root MySQL584295Sep +   -libmemcached.so-Rwxr-xr-X.1Root MySQL17539Sep +   -mypluglib.so-Rwxr-xr-X.1Root MySQL11913Sep +   -mysql_no_login.so-Rwxr-xr-X.1Root MySQL18151Sep +   -qa_auth_client.so-Rwxr-xr-X.1Root MySQL23798Sep +   -qa_auth_interface.so-Rwxr-xr-X.1Root MySQL12926Sep +   -qa_auth_server.so-Rwxr-xr-X.1Root MySQL421090Sep +   -semisync_master.so-Rwxr-xr-X.1Root MySQL250206Sep +   -semisync_slave.so-Rwxr-xr-X.1Root MySQL157141Sep +   -Validate_password.so

MY.CNF join:
plugin-load=validate_password.sovalidate-password=force_plus_permanent

Mysql>SHOW PLUGINS;+----------------------------+----------+--------------------+----------------------+---------+| Name | Status | Type | Library | License |+----------------------------+----------+--------------------+----------------------+---------+| Binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | Mysql_native_password | ACTIVE | Authentication | NULL | GPL | | Mysql_old_password | ACTIVE | Authentication | NULL | GPL | | Sha256_password | ACTIVE | Authentication | NULL | GPL | | Mrg_myisam | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGEENGINE | NULL | GPL | | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | | Innodb_trx | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_locks | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_lock_waits | 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_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_sys_tables | ACTIVE | Information SChema | NULL | GPL | | Innodb_sys_tablestats | ACTIVE | Information SCHEMA | NULL | GPL | | innodb_sys_indexes | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_sys_columns | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_sys_fields | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_sys_foreign | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_sys_foreign_cols | ACTIVE | Information SCHEMA | NULL | GPL | | innodb_sys_tablespaces | ACTIVE | Information SCHEMA | NULL | GPL | | Innodb_sys_datafiles | ACTIVE | Information SCHEMA | NULL | GPL | | Performance_schema | ACTIVE | STORAGE ENGINE | NULL | GPL | | Blackhole | ACTIVE | STORAGE ENGINE | NULL | GPL | | FederateD | DISABLED | STORAGE ENGINE | NULL | GPL | | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL | | Partition | ACTIVE | STORAGE ENGINE | NULL | GPL || validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL |+----------------------------+----------+--------------------+----------------------+---------+ +Rowsinch Set(0.01Sec

Mysql>SetPassword=password ("123"); ERROR1819(HY000): Your password does not satisfy the current policy requirementsmysql>SetPassword=password ("[email protected]"); ERROR1819(HY000): Your password does not satisfy the current policy requirementsmysql>SetPassword=password ("[email protected]"); Query OK,0Rows Affected (0.01Sec

Mysql>Show variables like"%Password%";+--------------------------------------+--------+|Variable_name|Value|+--------------------------------------+--------+| disconnect_on_expired_password | On ||Old_passwords| 0      ||Report_password|        ||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      |+--------------------------------------+--------+9Rowsinch Set(0.00Sec

The parameter validate_password_length is used to set the minimum length of the password, and the default value is 8.

The parameter validate_password_policy represents a password policy, which can be set to a value of0or low, which is only required to match the password length (as determined by the parameter Validate_password_ Length specified)1or  MEDIUM satisfies the low policy, and also satisfies at least 1 digits, lowercase letters, uppercase letters and special characters 2or file ) in
It can be found that the PvP is also powerful in the strong mode can also set the dictionary file, the dictionary exists in the password must not be used.
You can set the dictionary file by using the parameter validate_password_dictionary_file. But as for inside June, it seems that the security of medium strategy is high enough.

Start MySQL Password audit plugin