MySQL解决-Error:Your password does not satisfy the current policy requirements

背景

MySQL版本：Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)

前言

今天打算在MySQL创建用户时遇到了下面这个错误：

mysql> CREATE USER IF NOT EXISTS 'yingming006'@'%' IDENTIFIED BY 'yingming006';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

这是因为MySQL默认的密码策略问题，输入以下命令查看当前的密码策略设置

SHOW VARIABLES LIKE 'validate_password%'

+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    |