MySQL Cryptographic decryption function

Source: Internet
Author: User
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.