mysql8.0修改密码出现ERROR 1819 (HY000)_mysql> alter user 'root'@'localhost' identified by

问题描述：

mysql版本：Server version: 8.0.28 MySQL Community Server - GPL 初次使用修改密码出现ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

---

原因分析：

根据英文描述可知密码不够安全，但是我自己使用，想设置成123456

---

解决方案：

先查看密码验证的相关参数，如果没有数据的话就需要安装validate_password插件。

SHOW VARIABLES LIKE 'validate_password%';
1

需要关注的有4个参数validate_password.length，validate_password.policy，validate_password_length，validate_password_policy

validate_password_policy类型

Policy Tests Performed
0 or LOW Length
1 or MEDIUM Length; numeric, lowercase/uppercase, and special characters
2 or STRONG Length; numeric, lowercase/uppercase, and special characters; dictionary file

直接输入

set global validate_password_policy=0;
set global validate_password.policy=0;
set global validate_password_length=4;
set global validate_password.length=4;
1
2
3
4

然后即可修改密码为123456啦。

mysql>  alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
1
2