I cannot run queries using encryption from MySQL workbench. I need to run them from the mysql console.
SELECT id,AES_DECRYPT(firstname,UNHEX(SHA2('key',512))),AES_DECRYPT(lastname,UNHEX(SHA2('key',512))),AES_DECRYPT(email,UNHEX(SHA2('key',512))),AES_DECRYPT(password,UNHEX(SHA2('key',512))) FROM user WHERE AES_DECRYPT(lastname,UNHEX(SHA2('key',512))) LIKE '%lee%';
mysql -h 127.0.0.1 -u root -pXXXX -e "SET block_encryption_mode = 'aes-128-cbc';SET @enc_key='mywhateverkey';SET @bytes='0000000000000000';SELECT g.id,g.flag,AES_DECRYPT(FROM_BASE64(gc.firstname), @ENC_KEY, @BYTES) FROM guest AS g, guest_capa AS gc;" app_v2_e > i9011.db