easy_install mysql-connector-python
>>>import mysql.connector as conner >>> conn = conner.connect(user="root", passwd="kaimen", db="zentao", port=3306, pool_name = "mypool", pool_size = 3,) >>> cursor = conn.cursor() >>> cursor.execute("show tables"); >>> cursor.fetchall() [(u'task',)] >>> cursor = conn.cursor(cursor_class=conner.cursor.MySQLCursorDict) >>> cursor.execute("show tables"); >>> cursor.fetchall() [{u'Tables_in_zentao': u'task'}] >>> cursor = conn.cursor(dictionary=True) >>> cursor.execute("show tables"); >>> cursor.fetchall() [{u'Tables_in_zentao': u'task'}]
