'How to set mysql system variable (session variable ) in ejabberd

I tried to set MYSQL system variable in ejabberd for decrypt message(AES decryption) but its not working.

I tried below code:

ejabberd_sql:sql_query(FServer,
  [<<"SET SESSION block_encryption_mode = 'aes-256-cbc';">>]),


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source