import warnings
import pandas as pd
import numpy as np
import datetime as dt
import sys
import MySQLdb as MySQLdb
import math
from pandas.io import sql
import mysql.connector
from sqlalchemy import create_engine
import pymysql as pymysql

engine = create_engine("mysql+mysqlconnector://user:pass@rds.amazonaws.com/testSchema"
                       .format(user="root",
                               pw="varshaA1!",
                               db="testSchema"))
db = MySQLdb.connect(host="rds.amazonaws.com",    # your host, usually localhost
                     user="user",         # your username
                     password="pass",  # your password
                     database="testSchema")


result.to_sql(name='bucketFillTest',con=engine,if_exists='replace',index=False)

db.close()