MySQL 8：密码策略设定

最新推荐文章于 2024-07-02 21:33:37 发布

淼叔

最新推荐文章于 2024-07-02 21:33:37 发布

阅读量2.3k

点赞数 1

分类专栏： # MySQL 文章标签： MySQL8 密码策略

本文链接：https://blog.csdn.net/liumiaocn/article/details/104424682

版权

本文介绍了在MySQL 8中遇到的密码策略问题。由于默认策略为中等(MEDIUM)，导致简单密码如'liumiao123'无法设置。解决方法是调整密码策略，通过执行特定SQL来降低标准。执行后，密码设定成功。

摘要由CSDN通过智能技术生成

在MySQL 8中，默认的密码策略进行了调节，这篇文章介绍调节和设定的方法。

环境说明

操作系统版本: 10.15.2

liumiaocn:target liumiao$ sw_vers
ProductName:	Mac OS X
ProductVersion:	10.15.2
BuildVersion:	19C57
liumiaocn:target liumiao$

MySQL版本: 8.0.11

liumiaocn:target liumiao$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 46
Server version: 8.0.11 Homebrew

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

MySQL运行状态

liumiaocn:target liumiao$ mysql.server status
 SUCCESS! MySQL running (4633)
liumiaocn:target liumiao$

问题现象

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'liumiao123';
ERROR 1819 (HY000): Your password does not satisfy the current policy r