mysql修改连续数据库

USE db1;
UPDATE users SET status = 'active';

USE db2;
UPDATE users SET status = 'active';

DELIMITER //

CREATE PROCEDURE UpdateUsersStatus()
BEGIN
    UPDATE db1.users SET status = 'active';
    UPDATE db2.users SET status = 'active';
END //

DELIMITER ;

CALL UpdateUsersStatus();

import mysql.connector

def update_users_status(host, user, password):
    databases = ['db1', 'db2']
    
    for db in databases:
        conn = mysql.connector.connect(host=host, user=user, password=password, database=db)
        cursor = conn.cursor()
        cursor.execute("UPDATE users SET status = 'active'")
        conn.commit()
        cursor.close()
        conn.close()

# 调用函数
update_users_status('localhost', 'your_user', 'your_password')

GRANT ALL PRIVILEGES ON db1.* TO 'your_user'@'localhost';
GRANT ALL PRIVILEGES ON db2.* TO 'your_user'@'localhost';
FLUSH PRIVILEGES;

START TRANSACTION;
UPDATE db1.users SET status = 'active';
UPDATE db2.users SET status = 'active';
COMMIT;