先修改密码(设置复杂密码,可从初始化密码基础上修改)
SET PASSWORD = PASSWORD('waTf3xi3l7(<');
修改密码复杂度为低,设置密码位数
set global validate_password_policy=LOW;
set global validate_password_length=6;(六位数)
再次修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
刷新生效:***重点!!
flush privileges;