AES_ENCRYPT()

Overview

Encrypts data using the AES algorithm with the given key.

EXAMPLES

SELECT SUBSTRING(HEX(AES_ENCRYPT('This is a test string to encrypt',
  'This is the AES key to use')), 1, 32) AS HexSubstring;
+----------------------------------+
| HexSubstring                     |
+----------------------------------+
| C3448D2B75B4C4F32221F78B7098FCBE |
+----------------------------------+
SET @key_str = SHA2('passphrase',512);
SELECT HEX(AES_ENCRYPT('text', @key_str)) AS HexString;
+----------------------------------+
| HexString                        |
+----------------------------------+
| 09F25245882D04F8AE24FDD5D887B157 |
+----------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES