当修改mysql密码时报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql设置密码时报错 Your password does not satisfy the current policy requirements(修改·mysql密码策略设置简单密码)_mysql

说明你的密码没有达到mysql的密码策略的要求

查看密码策略:

SHOW VARIABLES LIKE 'validate_password%'; 

mysql设置密码时报错 Your password does not satisfy the current policy requirements(修改·mysql密码策略设置简单密码)_mysql_02

降低密码的强度以及设置密码的长度为6

 set global validate_password_policy=LOW; 
set global validate_password_length=6;


mysql设置密码时报错 Your password does not satisfy the current policy requirements(修改·mysql密码策略设置简单密码)_mysql_03

查看修改后的密码策略

mysql设置密码时报错 Your password does not satisfy the current policy requirements(修改·mysql密码策略设置简单密码)_mysql_04

此时就可以设置简单密码了,如123456