MySQL Symmetric Encryption

> select hex(aes_encrypt(rpad("abcqweqweqweqwe",31,"~"),"mykey")) as encrypted;
+------------------------------------------------------------------+
| encrypted                                                        |
+------------------------------------------------------------------+
| E5FB394568B8F03D43CF083F5065C959AC6E22BDB7749E4D97F5ABC72B08D843 |
+------------------------------------------------------------------+

> select trim(trailing "~" from aes_decrypt(unhex("E5FB394568B8F03D43CF083F5065C959AC6E22BDB7749E4D97F5ABC72B08D843"),"mykey")) as decrypted;
+-----------------+
| decrypted       |
+-----------------+
| abcqweqweqweqwe |
+-----------------+