[python3 db connection] Connect to mysql using python3 #pymysql

connect.py

from optparse import OptionParser
import pymysql

# Get options from the command line
parser = OptionParser()
parser.add_option("-d", "--database", dest="database", action="store", type="string", help="Name of database you wish to connect to", metavar="DATABASE")
parser.add_option("-H", "--host", dest="host", action="store", type="string", help="Database host", metavar="HOST")
parser.add_option("-u", "--user", dest="user", action="store", type="string", help="User name", metavar="NAME")
parser.add_option("-p", "--password", dest="password", action="store", type="string", help="Password", metavar="PASSWORD")

(options, args) = parser.parse_args()


# Open database connection
db = pymysql.connect(options.host,options.user,options.password,options.database )