登录注册数据库

import mysql.connector
from mysql.connector import Error

def create_connection():
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='user_db',
                                             user='root',
                                             password='password')
        if connection.is_connected():
            print("Connection to MySQL DB successful")
        return connection
    except Error as e:
        print(f"The error '{e}' occurred")

def insert_user(connection, user):
    cursor = connection.cursor()
    query = "INSERT INTO users (username, email, password) VALUES (%s, %s, %s)"
    cursor.execute(query, user)
    connection.commit()
    print("User inserted successfully")

def main():
    connection = create_connection()

    user = ("john_doe", "john@example.com", "hashed_password")
    insert_user(connection, user)

    connection.close()

if __name__ == "__main__":
    main()