http://blog.csdn.net/wh62592855/article/details/6777753
There are several cryptographic functions under MySQL.
PASSWORD (): Creates an encrypted password string that is appropriate for the security system inserted into MySQL
Ec The encryption process is irreversible, and the UNIX password encryption process uses a different algorithm. Mainly used in the MySQL authentication system.
ENCRYPT (,): Use the Unix crypt () system to encrypt the string, the ENCRYPT () function receives the string to encrypt and (optionally) the salt used for the encryption process (a string that uniquely determines the password, just like the key), note that Windows does not support
ENCODE (,) DECODE (,): encrypts the decrypted string. The function has two parameters: a string that is encrypted or decrypted, and a key that is the basis for encryption or decryption. The encode result is a binary string that is stored as a BLOB type. The degree of encryption is relatively weak
MD5 (): Computes the MD5 checksum of a string (128-bit)
SHA5 (): Computes the SHA5 checksum of a string (160-bit)
The checksum returned by the above two functions is 16 binary and is appropriate for the password used in the authentication system. MySQL Official document encryption function What kind of encryption algorithm does the password function in MySQL use? Using the MySQL function to the function of the password function of the encrypted value to crack the MySQL's own database Aes_ encryption and Aes_ decryption function
MySQL Cryptographic decryption function