Centos下rpm安装MySQL5.7后创建用户提示不符合密码策略

概述

因项目需要部署MySQL5.7服务，并创建对应库及用户。

mysql> create user 'test'@'%' identified by 'test@123';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

解决办法

mysql> set global validate_password_policy=LOW;
Query OK, 0 rows affected (0.00 sec)

mysql> create user "test"@"%" identified by "test@123";
Query OK, 0 rows affected (0.00 sec)