1.获取初始密码
vim /var/log/mysqld.log
2.修改密码
(注:只有修改初始密码后才可以进行下一步操作)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ww_123456';
3.查询当前密码策略
show variables like '%password%';
4.修改密码策略
(1) 将密码强度设置为简单
set global validate_password_policy=LOW;
(2) 将密码长度设置为6位
set global validate_password_length=6;
5.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';