#新建一个数据数据库做pass[两个字段一个id,一个pss自己的密码],数据库账号为root,密码为root,数据库为root
#第一步导入库
import itertools as its
import pymysql
import hashlib
#aa=(datetime.datetime.now().strftime(‘%H:%M:%S.%f’))
#第二步:连接数据库
conn = pymysql.connect(host=‘localhost’,
port=3306, user=‘root’,
password=‘root’,
database=‘root’,
charset=‘utf8’)
cursor = conn.cursor()
#第三步生成随机密码【从第一位开始计算】
i = 0
words=“1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*()-_:;<>?/\”
for num in range(1,68):
keys = its.product(words, repeat=num)
for key in keys:
kee=(“”.join(key))
i=i+1
sql = “insert into pass(id,pss) values (%s, %s,)”
par=(i,kee)
try:
row_count = cursor.execute(sql,par)
conn.commit()
except:
print(‘数据库出错了’)
conn.rollback()
finally:
cursor.close()
conn.close()
***期待您的建议哦