https://dev.mysql.com/downloads/connector/python/

  
import pymysql.connections
 
def get_data():
    conn = pymysql.connections.Connection(
        host='localhost',
        user='',
        passwd='',
        port=3306,
        database='test',
        charset='utf8')
    cur = conn.cursor()
    cur.execute('select * from tab')
    out = cur.fetchall()
    conn.close()
    return out