Their documentation is not fully clear to me.

So, the 'my secret passphrase' is nothing supplied by a user then?
Something the programmer supplies for AES encrypt?

'text' would have been the thing to be encrypted? User supplied?

What is @crypt string?
looks like the AES encryption of 'text' with the modification including @key_str,@init_vector variables?


mysql> SET @crypt_str = AES_ENCRYPT('text',@key_str,@init_vector);

MariaDB [booksgood]> select @crypt_str;
+------------------+
| @crypt_str |
+------------------+
| ?S?13N?????1?tv |
+------------------+
1 row in set (0.000 sec)