Your password does not satisfy the current policy requirements

mysql使用root账号创建用户并授予权限报错😭

create user my@‘%’ IDENTIFIED by ‘my’;

1. 查看当前密码安全策略😄

select @@validate_password_policy;

2. 查看具体的设置项😊

SHOW VARIABLES LIKE ‘validate_password%’;

3. 修改validate_password_policy参数的值（等级为0）😎

set global validate_password_policy=0;

set global validate_password_length=1;

4. 执行成功😋

create user my@‘%’ IDENTIFIED by ‘my’;