初次安装mysql8 设置密码为root

初次安装mysql8 将密码设置为root时报错：ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
，要想解决这个问题，首先是我们需要先设置一个符合要求的密码，之后再将密码设置为‘root’。具体步骤如下：
1.例如，我们现将密码设置为SS!123456

ALTER USER 'root'@'localhost' IDENTIFIED BY 'SS!123456';

2.查看当前规则

SHOW VARIABLES LIKE 'validate_password%';

• 修改密码策略等级

mysql> set global validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)

• 设置是否校验

mysql> set global validate_password.check_user_name=off;
Query OK, 0 rows affected (0.00 sec)

• 设置长度至少为1

mysql>  set global validate_password.length=1;
Query OK, 0 rows affected (0.01 sec)

4.修改密码为root

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Query OK, 0 rows affected (0.01 sec)