ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题解决

最新推荐文章于 2025-03-22 15:38:55 发布

卡尔一点也不卡

最新推荐文章于 2025-03-22 15:38:55 发布

阅读量655

点赞数 1

分类专栏： mysql 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/qq_34316431/article/details/119003853

版权

mysql 专栏收录该内容

3 篇文章

订阅专栏

操作数据库时提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题。
原因是因为Mysql增加了密码强度验证插件：validate_password，去网上查原因都是是因为设置的密码太简单了，才会出现这个问题，但是我设置的挺复杂的，莫名其妙(｀・ω・´)

解决办法：
进入到mysql，依次输入一下命令即可解决：

mysql> SHOW VARIABLES LIKE ‘validate_password%’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘validate_password%’' at line 1
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

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

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

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

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

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>