Skip to main content

密码策略

查看密码策略.

SHOW VARIABLES LIKE "%password%";

修改密码策略,修改密码总长度,我这边改成5,为了安全建议8位左右

SET GLOBAL validate_password_length=5;

修改密码强度策略,我这边改成低策略就不需要大小写数字和符号了

SET GLOBAL validate_password_policy=0;
-- create user 'm189'@'localhost' identified by 'root';
grant select,insert,delete,update on test.* to  'm189'@'localhost' identified by 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;