pip install mysqlclient

import MySQLdb
conn = MySQLdb.connect(host="localhost",user="root",passwd="12345678",db="pythontest",charset="utf8")
cur = conn.cursor()
# 写入
cur.execute("create table users(id int(2) not null primary key auto_increment,username varchar(40),password text,email text)default charset=utf8;")
cur.execute("insert into users(username,password,email) values('qiwsir','123123','qiwsir@gmail.com')")
conn.commit()
# 查询
cur.execute("select * from users")
lines = cur.fetchall()
for line in lines:
    print(line)
cur.close()
conn.close()