python使用pyodbc

一、确认机器安装配置好unixodbc

二、pip安装pyodbc

pip3 install pyodbc

三、编写程序并运行

# coding=utf-8 

import pyodbc

pyodbc.pooling = False

print(pyodbc.drivers())

cnxn = pyodbc.connect('DRIVER={MySQL};User=root;Password=;Server=Port=;')

cursor = cnxn.cursor()
cursor.execute("show databases")
rows = cursor.fetchall()
for row in rows:
    print(row)

python3 a.python即可