sudo apt-get install python-mysqldb

import MySQLdb

sudo dpkg -i mysql-connector-python_2.1.6-1ubuntu16.10_all.deb

sudo apt-get remove python-mysqldb

$sudo apt-get install libmysqlclient-dev
$cd to project dir (myproj)
$virtualenv -p /usr/bin/python3 env
$source env/bin/activate
(env) pip install mysqlclient
(env) deactivate

$source env/bin/activate
(env)python3
>>> import MySQLdb
>>> db = MySQLdb.connect(host="localhost", user="u", passwd="secret", db="mydb")
>>> cur = db.cursor()
>>> cur.execute("select * from a-table")
>>> for row in cur.fetchall():
       print(row[0])
>>> db.close()

If you are using virtualenv
    $ `virtualenv -p python3 venv`
    $ `source venv/bin/activate`
    $ `pip install pymysql`

If you are using virtualenvwrapper
    $ `mkvirtualenv venv --python=/usr/bin/python3`
    $ `pip install pymysql`