mysql数据库的数据写不进去

SHOW GRANTS FOR 'username'@'host';
GRANT INSERT ON database_name.table_name TO 'username'@'host';

df -h

INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2');

START TRANSACTION;
-- 执行一系列 SQL 语句
COMMIT;

import mysql.connector

try:
    conn = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    cursor = conn.cursor()
    
    sql = "INSERT INTO employees (name, position) VALUES (%s, %s)"
    val = ("John Doe", "Software Engineer")
    cursor.execute(sql, val)
    
    conn.commit()
    print(cursor.rowcount, "record inserted.")
except mysql.connector.Error as err:
    print("Something went wrong: {}".format(err))
finally:
    if conn.is_connected():
        cursor.close()
        conn.close()