下载对应版本 安装
https://dev.mysql.com/downloads/connector/python/
创建链接
# python 链接mysql
import mysql.connector
con = mysql.connector.connect(
host = "localhost",port = "3306",
user = "root",password = "",
database = "demo"
)
cursor = con.cursor()
sql = "select empno,ename,hiredate from t_emp;"
cursor.execute(sql)
for one in cursor:
print(one[0],one[1],one[2])
con.close()