You must reset your password using ALTER USER statement before executing this statement.

执行sql语句时，出现异常如下：

You must reset your password using ALTER USER statement before executing this statement.

此时，设置密码（复杂一些，等会调整完密码策略再改回来）

mysql> ALTER USER USER() IDENTIFIED BY 'Wqq123456@';

设置成功，查看策略：

mysql> SHOW VARIABLES LIKE 'validate_password%';

调低策略强度：

mysql> set global validate_password_policy=LOW;

mysql> set global validate_password_length=6;

成功之后，再次设置密码：

mysql> ALTER USER USER() IDENTIFIED BY '123456';

=================================================================
个人博客
Github
个人公众号：Flutter小同学

个人网站