ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

小咪咪 2023-06-15 07:20 21阅读 0赞

为了加强安全性，MySQL5.7为root用户随机生成了一个密码，在error log中，关于error log的位置，如果安装的是RPM包，则默认是/var/log/mysqld.log。

一般可通过log\_error设置

mysql> select @@log_error;
    +---------------------+
    | @@log_error         |
    +---------------------+
    | /var/log/mysqld.log |
    +---------------------+
    row in set (0.00 sec)

可通过\# grep “password” /var/log/mysqld.log 命令获取MySQL的临时密码

[Note] A temporary password is generated for root@localhost: waQ,qR%be2(5

用该密码登录到服务端后，必须马上修改密码，不然会报如下错误：

mysql> select user();
    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

如果只是修改为一个简单的密码，会报以下错误：

mysql>  ALTER USER USER() IDENTIFIED BY '12345678';
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

这个其实与validate\_password\_policy的值有关。

validate\_password\_policy有以下取值：  
![在这里插入图片描述][20191121113223688.png]  
默认是1，即MEDIUM，所以刚开始设置的密码必须符合长度，且必须含有数字，小写或大写字母，特殊字符。

有时候，只是为了自己测试，不想密码设置得那么复杂，譬如说，我只想设置root的密码为123456。

必须修改两个全局参数：

首先，修改validate\_password\_policy参数的值

mysql> set global validate_password_policy=0;
    Query OK, 0 rows affected (0.00 sec)

这样，判断密码的标准就基于密码的长度了。这个由validate\_password\_length参数来决定。

mysql> select @@validate_password_length;
    +----------------------------+
    | @@validate_password_length |
    +----------------------------+
    |                          8 |
    +----------------------------+
    row in set (0.00 sec)

[修改密码][Link 1]

[20191121113223688.png]: https://img-blog.csdnimg.cn/20191121113223688.png
[Link 1]: https://blog.csdn.net/qq_43193386/article/details/98063040

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

发表评论取消回复

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

相关阅读

相关 MYSQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 mysql报错 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

相关 ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen 【mysql】