具体步骤:
1、修改my.ini,添加插件的路径(注意路径中是否有validate_password.dll文件,有该文件才支持密码策略)
plugindir="D:/Program Files/mysql/mysql-5.6.34-winx64/lib/plugin"
plugin-load=validate_password.dll
validate-password=FORCE_PLUS_PERMANENT
2、执行INSTALL PLUGIN validate_password SONAME 'validate_password.dll',安装 validate_password插件;
3、查看策略,执行show variables like 'validate_password%';
开启成功!