通过 Python 将密码 hash 后存入 MySQL 数据库中, 构建一个自己的密码库
MySQL 版本: 5.6
python 版本: 3.6
pycharm:community 2019.2.4
创建相关表
- CREATE TABLE society.18wangcode_sha1_hash(id INT(9) AUTO_INCREMENT PRIMARY KEY,
- pwd VARCHAR(60) NOT NULL,
- hash_values VARCHAR(40) NOT NULL);
Python 代码
通过 hashlib 库将密码 hash 后存入数据库
- import mysqlx.connection
- import time
- import hashlib
- import MySQL.connector
- print('begin'.center(30, '*'))
- print('进行中, 请稍等........')
- start = time.time()
- conn = MySQL.connector.connect(host='192.168.137.239', user='admin', password='123456', database='society')
- cursor = conn.cursor()
- def hash(pwd):
- method = hashlib.sha1()
- method.update(pwd.encode('utf-8', errors='ignore'))
- return method.hexdigest()
- try:
- with open(r'C:\Users\11826\Desktop\18 万条密码. txt', 'r', encoding='utf-8', errors='ignore') as file:
- for password in file:
- cursor.execute('insert into society.18wangcode_sha1_hash (pwd, hash_values) values (%s, %s)',
- (password, hash(password)))
- except:
- print('error')
- finally:
- cursor.close()
- conn.commit()
- conn.close()
- end = time.time()
- print('结束, 共耗时:{:.2f} 秒'.format(end-start))
GitHub 地址
来源: http://www.bubuko.com/infodetail-3350001.html