mysql用户管理系统源码

import mysql.connector

def create_user(username, password, host='localhost'):
    try:
        conn = mysql.connector.connect(user='root', password='root_password')
        cursor = conn.cursor()
        cursor.execute(f"CREATE USER '{username}'@'{host}' IDENTIFIED BY '{password}'")
        cursor.execute(f"GRANT SELECT, INSERT ON *.* TO '{username}'@'{host}'")
        conn.commit()
        print(f"User '{username}' created successfully.")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        cursor.close()
        conn.close()

def delete_user(username, host='localhost'):
    try:
        conn = mysql.connector.connect(user='root', password='root_password')
        cursor = conn.cursor()
        cursor.execute(f"DROP USER '{username}'@'{host}'")
        conn.commit()
        print(f"User '{username}' deleted successfully.")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        cursor.close()
        conn.close()

# 示例调用
create_user('newuser', 'newpassword')
delete_user('newuser')