from mysql.connector import connect

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

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