mysql随机密码修改

import random
import string

def generate_random_password(length=16):
    characters = string.ascii_letters + string.digits + string.punctuation
    password = ''.join(random.choice(characters) for i in range(length))
    return password

random_password = generate_random_password()
print(random_password)

ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;

import mysql.connector

def change_password(username, new_password):
    try:
        conn = mysql.connector.connect(
            host="localhost",
            user="your_username",
            password="your_current_password"
        )
        cursor = conn.cursor()
        cursor.execute(f"ALTER USER '{username}'@'localhost' IDENTIFIED BY '{new_password}';")
        cursor.execute("FLUSH PRIVILEGES;")
        conn.commit()
        print("Password changed successfully.")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

change_password('username', 'new_random_password')