mysql错误1820 you must reset your password using...
mysql执行语句报错mysql> use mysql;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.提示要用ALTER USER修改密码才可以 但是如果想要设置非常简单的密码，比如123456会提示密码不符合要求mysql
·
mysql执行语句报错
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
提示要用ALTER USER修改密码才可以 但是如果想要设置非常简单的密码，比如123456会提示密码不符合要求
mysql> alter user 'root'@'localhost' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
/ / 但是修改这个参数会报错，没有这个系统变量
mysql> set global validate_password_policy=0;
ERROR 1193 (HY000): Unknown system variable 'validate_password_policy'
添加参数
这个时候就得去修改一下mysql的配置文件
[root@zheng ~]# vi /etc/my.cnf
[mysqld] ## 在mysqld文本段里添加这两行
#添加密码验证插件
plugin-load-add=validate_password.so
#服务器在启动时加载插件，并防止在服务器运行时删除插件
validate-password=FORCE_PLUS_PERMANENT
[root@zheng ~]# systemctl restart mysqld / / 修改完重启mysql
[root@zheng ~]# mysql -uroot -p
Enter password: 密码123
修改参数值
修改validate_password_policy参数的值
validate_password_length(密码长度)参数默认为8，我们修改为1
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> show databases; / / 这里就可以正常使用了
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
这里说一下，我这用的是5.7版本的，mysql8.0是不支持这么修改的
mysql> status
--------------
mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper
Connection id: 5
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.30
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 hour 58 min 34 sec
Threads: 1 Questions: 26 Slow queries: 0 Opens: 106 Flush tables: 1 Open tables: 99 Queries per second avg: 0.003
-
8.0mysql版本修改参数设置
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;
为开发者提供学习成长、分享交流、生态实践、资源工具等服务，帮助开发者快速成长。
更多推荐
5
0- 0
已为社区贡献3条内容
所有评论(0)