MySQL5.7密码安全策略修改

方法1

初始化时修改

mysqld --initialize-insecure ...

方法2

配置文件设置

[mysqld]
validate_password=off

登录数据库设置

set global validate_password_policy=0;
set global validate_password_length=0;

alter user 'root'@'localhost' identified by '123456';
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;