Your password does not satisfy the current policy requirements

mysql> create user 'test1'@'localhost' identified by '123456'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements  原因：密码策略问题  解决办法： 1.查看mysql初始的密码策略 mysql> show variables like 'validate_password%'; +--------------------------------------+--------+ | Variable_name                        | Value  | +--------------------------------------+--------+ | validate_password_check_user_name    | OFF    | | validate_password_dictionary_file    |        | | validate_password_length             | 8      | | validate_password_mixed_case_count   | 1      | | validate_password_number_count       | 1      | | validate_password_policy             | MEDIUM | | validate_password_special_char_count | 1      | +--------------------------------------+--------+ 7 rows in set (0.04 sec)  2.设置密码的验证强度等级，设置validate_password_policy的全局参数为LOW （修改为low后，就只验证密码的长度） set global validate_password_policy=LOW;  mysql> show variables like 'validate_password%'; +--------------------------------------+-------+ | Variable_name                        | Value | +--------------------------------------+-------+ | validate_password_check_user_name    | OFF   | | validate_password_dictionary_file    |       | | validate_password_length             | 8     | | validate_password_mixed_case_count   | 1     | | validate_password_number_count       | 1     | | validate_password_policy             | LOW   | | validate_password_special_char_count | 1     | +--------------------------------------+-------+ 7 rows in set (0.00 sec)  3.修改密码长度 set global validate_password_length=6;  mysql> show variables like 'validate_password%'; +--------------------------------------+-------+ | Variable_name                        | Value | +--------------------------------------+-------+ | validate_password_check_user_name    | OFF   | | validate_password_dictionary_file    |       | | validate_password_length             | 6     | | validate_password_mixed_case_count   | 1     | | validate_password_number_count       | 1     | | validate_password_policy             | LOW   | | validate_password_special_char_count | 1     | +--------------------------------------+-------+ 7 rows in set (0.01 sec)  4.验证 mysql> create user 'test1'@'localhost' identified by '123456'; Query OK, 0 rows affected (0.06 sec)

你还在原价购买阿里云、腾讯云、华为云、天翼云产品？那就亏大啦！现在申请成为四大品牌云厂商VIP用户，可以3折优惠价购买云服务器等云产品，并且可享四大云服务商产品终身VIP优惠价，还等什么？赶紧点击下面对应链接免费申请VIP客户吧：

1、点击这里立即申请成为腾讯云VIP客户

2、点击这里立即注册成为天翼云VIP客户

3、点击这里立即申请成为华为云VIP客户

4、点击这里立享阿里云产品终身VIP优惠价

喜欢 (0)赏

[[email protected]]

分享 (0)