import mysql.connector
cnx = mysql.connector.connect(user='user', password='password', host='rds.amazonaws.com', database='dbname')
cursor = cnx.cursor()
query = ('SELECT * FROM table')
cursor.execute(query)
for row in cursor:
print(row)
cursor.close()
cnx.close()