dbconnect.py

import pymysql

def connection():
    conn = pymysql.connect(host='localhost',
                            user='flask',
                            password='',
                            db='flask',
                            charset='utf8mb4',
                            cursorclass=pymysql.cursors.DictCursor)
    c = conn.cursor()
    return c, conn