pip install mysql-connector

#连接数据库

#常规连接方式

conn = mysql.connector.connect(user='root', password='', database='test')

#我用了最新的8.0的mysql踩到这个坑，要在后面加上auth_plugin参数解决

conn = mysql.connector.connect(user="root", password="", database="test",auth_plugin='mysql_native_password')

cursor = conn.cursor()

#创建user表

cursor.execute("create table user(id varchar(20) primary key,name varchar(20))")

#插入数据

cursor.execute("insert into user(id,name) values(%s,%s)",["","Rose"])

cursor.execute("insert into user(id,name) values(%s,%s)",["","Curry"])

#查询数据

cursor.execute('select * from user where id = %s', ('',))

values = cursor.fetchall()

print (values)

#提交数据

conn.commit()

#查询数据库是否在运行

cursor = conn.cursor()

#关闭cursor和conn

cursor.close()

conn.close()

#查询输出

"C:\xxxxx路径"

[('', 'Rose')]

[('', 'Curry')]