强制修改mysql密码

-- 使用旧密码登录并修改密码
mysql -u root -pold_password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;

-- 查看当前的密码策略
SHOW VARIABLES LIKE 'validate_password%';

-- 修改密码策略（示例：降低密码长度要求）
SET GLOBAL validate_password.length = 6;

#!/bin/bash

# 定义旧密码和新密码
OLD_PASSWORD="old_password"
NEW_PASSWORD="new_password"

# 遍历所有MySQL实例并修改密码
for HOST in "localhost" "db1.example.com" "db2.example.com"; do
    mysql -u root -p$OLD_PASSWORD -h $HOST -e "ALTER USER 'root'@'$HOST' IDENTIFIED BY '$NEW_PASSWORD'; FLUSH PRIVILEGES;"
done