mysql客户端连接服务器的认证加密方式

# -*- coding: utf-8 -*-
'''
计算mysql的密码的加密方式, 密码的加密方式为：
SHA1(password) ^ SHA1(salt+ SHA1(SHA1(password)))
'''

import hashlib
import binascii
password = 'root'
salt = "\\gnu~<OXMWOe/VD4sk?6"

print("pwd:",password)
print("sat:",salt)
# ddc06d3f13da2398f9fffb0c12f4ca0cd0103f6e

# part1: SHA1(password)
sha1 = hashlib.sha1()
sha1.update(password.encode('utf-8'))
p1 = sha1.digest()
p1str = sha1.hexdigest()
print("pa1:",p1str,'<--- sha1(password)')

# part2: SHA1((SHA1(password))
sha2 = hashlib.sha1()
sha2.update(p1)
p2 = sha2.digest()
p2str = sha2.hexdigest()
print("pa2:",p2str,'<--- sha1(sha1(password))')

# part3: SHA1(salt+ SHA1(SHA1(password)))
sha3 = hashlib.sha1()
sha3.update(salt.encode('utf-8'))
sha3.update(p2)
p3 = sha3.digest()
p3str = sha3.hexdigest()
print("pa3:",p3str,'<--- sha1(salt+ sha1(sha1(password)))')

# part4: SHA1(password) ^ SHA1(salt+ SHA1(SHA1(password)))
p4 = bytearray(a^b for a,b in zip(p1,p3))
p4 =''.join(format(x, '02x') for x in p4)
print("pa4:",p4,'<--- sha1(password) ^ sha1(salt+ sha1(sha1(password)))')