使用Python实现数据加密

import pymysql
import hashlib
import base64
import rsa
db = pymysql.connect(host='******', user='****', password='****', db='******', charset='utf8')
cur = db.cursor()
sql = "SELECT * FROM user"
cur.execute(sql)

results = cur.fetchall()
for row in results:
    ip = row[0]
    userName = row[1]
    passWord = row[2]
#MD加密
    pwd_en = row[2].encode('utf-8')
    pwd_M=hashlib.md5(pwd_en)   #先创建一个md5的对象
    pwd_MD=pwd_M.hexdigest()    #获取密文
    print('ip=%s,name=%s,password=%s,password_MD=%s' % (ip, userName, passWord, pwd_MD))
#MD加salt
    pwd_M_salt=hashlib.md5(b'123345')  # 生成MD5对象 并加盐
    pwd_M_salt.update(passWord.encode('utf-8'))  # 对数据加密
    pwd_MD_salt = pwd_M_salt.hexdigest()
    print('MD5+salt加密后为 %s' % (pwd_MD_salt))

#Base64加密
    pwd_b64_en=base64.b64encode(pwd_en)
    pwd_b64_de=ba