python通過hashlib庫將密碼hash后存入數據庫

1. 通過Python將密碼hash后存入MySQL數據庫中，構建一個自己的密碼庫
   MySQL版本：5.6
   python 版本：3.6
   pycharm：community 2019.2.4
2. 創建相關表

   CREATE TABLE society.18wangcode_sha1_hash(id INT(9) AUTO_INCREMENT PRIMARY KEY,
   pwd VARCHAR(60) NOT NULL,
   hash_values VARCHAR(40) NOT NULL);

3. 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地址