python连接mysql数据库

import pymysql

def exec_sql(str_sql):
    results='数据库连接成功'
    try:
        pro_conn=pymysql.connect(host='10.1.1.2',user='roots',passwd='123456',db='databasename',port=3306)
    except:
        results='数据库连接出错'
    try:
        cur=pro_conn.cursor()
        cur.execute(str_sql)
    except:
        results = '执行SQL语句出错'
    finally:
        cur.close()

                    pro_conn.close()

         return results

注：需要自己安装mysql包，用pip install pymysql