Skip to content

Instantly share code, notes, and snippets.

@jkeefe

jkeefe/sratch.py

Created March 20, 2020 02:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jkeefe/968b3bce0406ceb87dc0fb88ac0a08ef to your computer and use it in GitHub Desktop.
Save jkeefe/968b3bce0406ceb87dc0fb88ac0a08ef to your computer and use it in GitHub Desktop.
Download ZIP
pymysql connection setup
Raw
sratch.py
import pandas as pd
import pymysql
host="very.long.endpoint.definition.amazonaws.com"
port=3306
dbname="your_database_name"
user="your_user_name"
password="your_password"
conn = pymysql.connect(host, user=user,port=port,
passwd=password, db=dbname)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment