输入的数据不会进入sql数据库

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    if connection.is_connected():
        print("Connected to the database")
except mysql.connector.Error as err:
    print(f"Error: '{err}'")

GRANT INSERT ON yourdatabase.yourtable TO 'yourusername'@'localhost';

cursor = connection.cursor()
sql_insert_query = """INSERT INTO yourtable (column1, column2) VALUES (%s, %s)"""
insert_tuple = ("value1", "value2")
cursor.execute(sql_insert_query, insert_tuple)
connection.commit()

CREATE TABLE yourtable (
    column1 VARCHAR(50),
    column2 INT
);

try:
    cursor.execute(sql_insert_query, insert_tuple)
    connection.commit()
except mysql.connector.Error as err:
    print(f"Error: '{err}'")
    connection.rollback()