import mysql.connector

conn = mysql.connector.connect(
    database="test",
    host="127.0.0.1",
    port=4000,
    user="root",
    password="",
)
cursor = conn.cursor()
query_setup = "CREATE TABLE IF NOT EXISTS t1 (pk INT, name CHAR(30))"
query_insert = "INSERT INTO t1 (pk, name) VALUES (%s, %s)"
cursor.execute(query_setup)
cursor.execute(query_insert, (1, "ABC"))
conn.commit()
cursor.close()
conn.close()