import pymysql as pm
import pandas as pd
hostname = 'hidden.on.purpose.amazonaws.com' #Your AWS RDS endpoint
username = 'testdblogin'
password = 'testdbpwd'
dbname = 'testdb'
dbport=3306

# To access from localhost Ensure host is made publicly available as YES
# To access from EC2, ensure VPC Group ID is added in Inbound rules
conn=pm.connect(hostname,user=username,port=dbport,passwd=password,db=dbname)
print('connection successfull')
print(pd.read_sql('show databases',con=conn))
conn.close()
print('Connection Closed')