MySQL 5.7设置简单密码报错ERROR 1819 (HY000)(2)

mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password_dictionary_file    |      |
| validate_password_length            | 3    |
| validate_password_mixed_case_count  | 0    |
| validate_password_number_count      | 3    |
| validate_password_policy            | LOW  |
| validate_password_special_char_count | 0    |
+--------------------------------------+-------+
6 rows in set (0.00 sec)

4）修改简单密码：

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');
Query OK, 0 rows affected, 1 warning (0.00 sec)

OK了，完美解决！