mysql密码复杂度查询

import mysql.connector

def check_password_complexity(password):
    length = len(password)
    has_upper = any(c.isupper() for c in password)
    has_lower = any(c.islower() for c in password)
    has_digit = any(c.isdigit() for c in password)
    has_special = any(c in "!@#$%^&*()" for c in password)
    
    complexity = {
        "length": length,
        "has_upper": has_upper,
        "has_lower": has_lower,
        "has_digit": has_digit,
        "has_special": has_special
    }
    
    return complexity

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 查询所有用户及其密码
cursor.execute("SELECT User, Password FROM mysql.user")

for (user, password) in cursor:
    complexity = check_password_complexity(password)
    print(f"User: {user}, Password Complexity: {complexity}")

cursor.close()
db.close()

[mysqld]
validate_password_policy=MEDIUM
validate_password_length=8
validate_password_mixed_case_count=1
validate_password_number_count=1
validate_password_special_char_count=1