mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before

矫情吗；* 2024-01-14 06:17 22阅读 0赞

### mysql初始化密码常见报错问题 ###

1，mysql5.6是密码为空直接进入数据库的，但是mysql5.7就需要初始密码

cat /var/log/mysqld.log | grep password

如下所示

[root@localhost Downloads]# cat /var/log/mysqld.log | grep password
    2019-05-30T03:02:26.373423Z 1 [Note] A temporary password is generated for root@localhost: 0Dih/Ylk,atq
    2019-05-30T03:50:38.539037Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)

2，然后执行 `mysql -uroot -p` ，输入上面的到的密码进入，用该密码登录后，必须马上修改新的密码，不然会报如下错误：

mysql> SET PASSWORD FOR 'root'@'localhost'="jack123456.";
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

3，如果你想要设置一个简单的测试密码的话，比如设置为123456，会提示这个错误，报错的意思就是你的密码不符合要求

mysql> alter user 'root'@'localhost' identified by '123456';
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

这个就跟mysql的密码策略有关系了：

（1）查看 mysql 初始的密码策略，  
输入语句 “ SHOW VARIABLES LIKE 'validate\_password%'; ” 进行查看，

（2）首先需要设置密码的验证强度等级，设置 validate\_password\_policy 的全局参数为 LOW 即可，  
输入设值语句 “ set global validate\_password\_policy=LOW或者0; ” 进行设值

mysql> set global validate_password_policy=0;

修改为low之后就只验证密码的长度了

（3）当前密码长度为 8 ，如果不介意的话就不用修改了，按照通用的来讲，设置为 6 位的密码，设置 validate\_password\_length 的全局参数为 6 即可，  
输入设值语句 “ set global validate\_password\_length=6; ” 进行设值

mysql> set global validate_password_length=6;

（4）完成之后再次执行修改密码语句即可成功

mysql> alter user 'root'@'localhost' identified by '123456';
    Query OK, 0 rows affected (0.10 sec)

关于 mysql 密码策略相关参数；  
1）、validate\_password\_length 固定密码的总长度；  
2）、validate\_password\_dictionary\_file 指定密码验证的文件路径；  
3）、validate\_password\_mixed\_case\_count 整个密码中至少要包含大/小写字母的总个数；  
4）、validate\_password\_number\_count 整个密码中至少要包含阿拉伯数字的个数；  
5）、validate\_password\_policy 指定密码的强度验证等级，默认为 MEDIUM；  
关于 validate\_password\_policy 的取值：  
0/LOW：只验证长度；  
1/MEDIUM：验证长度、数字、大小写、特殊字符；  
2/STRONG：验证长度、数字、大小写、特殊字符、字典文件；  
6）、validate\_password\_special\_char\_count 整个密码中至少要包含特殊字符的个数；

mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this s

相关 mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before

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

相关 mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin

相关解决 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing

相关 mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before

相关登录mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER ......

相关 centos安装完mysql报错：You must reset your password using ALTER USER statement before

相关 mysql报错：You must reset your password using ALTER USER statement before executing this statement.

相关 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this