当前位置：网站首页>Your password does not satisfy the current policy requirements

Your password does not satisfy the current policy requirements

2022-04-22 16:46:00 【Recalling the world】

First , This is because your password is not strong enough
Let's first set a passable password 

alter user 'root'@'localhost'  identified by  'Root_12root';

then , We can access the database normally , Take a look at the variables related to password authentication 

SHOW VARIABLES LIKE 'validate_password%';

Insert picture description here

We revise them one by one , It's like this
Insert picture description here 

set global validate_password.check_user_name=OFF;
set global validate_password.length=0;
set global validate_password.check_user_name=OFF;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.policy=LOW;
set global validate_password.special_char_count=0;

The password can be changed normally now 了 

#  Change the password to  root
alter user 'root'@'localhost'  identified by  'root';

版权声明
本文为[Recalling the world]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221638051215.html

边栏推荐

猜你喜欢

随机推荐