import pymysql.cursors

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='password',
                             db='dbname',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        with open('temp.txt') as file:
            for line in file:
                query = "DROP TABLE IF EXISTS " + line
                cursor.execute(query)
    connection.commit()

finally:
    connection.close()