MySQL offers many built-in encryption and compression functions. This section describes the functions that can be used to encrypt and decrypt string using different algorithms.
Function | Description |
---|---|
AES_DECRYPT() | Decrypt using AES |
AES_ENCRYPT() | Encrypt using AES |
ASYMMETRIC_DECRYPT() | Decrypt ciphertext using private or public key |
ASYMMETRIC_DERIVE() | Derive symmetric key from asymmetric keys |
ASYMMETRIC_ENCRYPT() | Encrypt cleartext using private or public key |
ASYMMETRIC_SIGN() | Generate signature from digest |
ASYMMETRIC_VERIFY() | Verify that signature matches digest |
COMPRESS() | Return result as a binary string |
CREATE_ASYMMETRIC_PRIV_KEY() | Create private key |
CREATE_ASYMMETRIC_PUB_KEY() | Create public key |
CREATE_DH_PARAMETERS() | Generate shared DH secret |
CREATE_DIGEST() | Generate digest from string |
DECODE() (deprecated 5.7.2) | Decodes a string encrypted using ENCODE() |
DES_DECRYPT() (deprecated 5.7.6) | Decrypt a string |
DES_ENCRYPT() (deprecated 5.7.6) | Encrypt a string |
ENCODE() (deprecated 5.7.2) | Encode a string |
ENCRYPT() (deprecated 5.7.6) | Encrypt a string |
MD5() | Calculate MD5 checksum |
OLD_PASSWORD() | Return the value of the pre-4.1 implementation of PASSWORD |
PASSWORD() (deprecated 5.7.6) | Calculate and return a password string |
RANDOM_BYTES() | Return a random byte vector |
SHA1(), SHA() | Calculate an SHA-1 160-bit checksum |
SHA2() | Calculate an SHA-2 checksum |
UNCOMPRESS() | Uncompress a string compressed |
UNCOMPRESSED_LENGTH() | Return the length of a string before compression |
VALIDATE_PASSWORD_STRENGTH() | Determine strength of password |