from mysql.connector import connect

conn = connect(
  database='test',
  host='127.0.0.1',
  port=4000,
  user='root',
  password='oh_you_can_really_dance'
)

print('Connected',conn)
cursor = conn.cursor(prepared=True)
query_setup = \
  '''
  create table if not exists t1 (id int, name char(30))
  '''
query_insert = \
  '''
  insert into t1 (id, name) values (%s, %s)
  '''
cursor.execute(query_setup)
cursor.execute(query_insert, (101, 'XYZ'))
conn.commit()
cursor.close()
conn.close()
print('Bye')