用python连接mysql数据库

开发中需要python连接mysql
python版本 3.7.0
mysql版本 5.7.32 community
下载mysql-connector包
#python -m pip install mysql-connector
在spyder中测试一下

import mysql.connector

mydb = mysql.connector.connect(
host="localhost",
user="zhangsan",
passwd="xxxxxxx"
)

print(mydb)

运行后打印出<mysql.connector.connection.MySQLConnection object at 0x000000C97F6605F8>

成功