MySQL8.0.36怎么设置简单密码

1. 环境查看
   系统环境

# cat /etc/redhat-release 
Rocky Linux release 9.3 (Blue Onyx)
[root@Rocky9MySQLTest003104 ~]# uname -a
Linux Rocky9MySQLTest003104 5.14.0-362.8.1.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Nov 8 17:36:32 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

软件环境

# mysql --version
mysql  Ver 8.0.36 for Linux on x86_64 (MySQL Community Server - GPL)

2. 设置
   使用管理员账户登录MySQL进行设置

-- 先确认密码校验组件和变量是否存在
SHOW VARIABLES LIKE 'validate_password%';

-- 降低密码复杂度，当前运行立即生效
SET GLOBAL validate_password.policy = 'LOW';
SET GLOBAL validate_password.length = 4;
SET GLOBAL validate_password.number_count = 0;
SET GLOBAL validate_password.mixed_case_count = 0;
SET GLOBAL validate_password.special_char_count = 0;
SET GLOBAL validate_password.check_user_name = OFF;

-- 将上述配置写入 mysqld-auto.cnf，重启后仍然保留
SET PERSIST validate_password.policy = 'LOW';
SET PERSIST validate_password.length = 4;
SET PERSIST validate_password.number_count = 0;
SET PERSIST validate_password.mixed_case_count = 0;
SET PERSIST validate_password.special_char_count = 0;
SET PERSIST validate_password.check_user_name = OFF;

-- 修改 root@localhost 的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';