0

I want to change AES encryption mode to CBC from DEFAULT ECB, I executed the following query to change mode: My MySQL version is 5.6.10

SET block_encryption_mode = 'aes-128-cbc'

This gives following error:

ERROR CODE 1193 - Unknown system variable 'block_encryption_mode'

BUT my other machine (AWS machine) installed the same version of MySQL on that machine below statement run successfully Mysql version is 5.6.10

SET block_encryption_mode = 'aes-128-cbc'

Can anyone let me know how to solve this error?

Thanks in advance

Improve this question
3
  • dev.mysql.com/doc/refman/8.0/en/… An error occurs for attempts to set block_encryption_mode to a value containing an unsupported key length or a mode that the SSL library does not support. Also ensure that the server was compiled with SSL support included - dev.mysql.com/doc/refman/8.0/en/… , and that SSL is not disabled - dev.mysql.com/doc/refman/8.0/en/… Commented Dec 10, 2021 at 10:11
  • I am working on a Windows machine and the Mysql server version is 5.6.10. Commented Dec 17, 2021 at 10:34
  • No problems, switch to the documentation for your version (use selector in right upper corner). Or replace /8.0/ substring with /5.6/ in URL. Commented Dec 17, 2021 at 10:44
Related questions
3
MySQL Error Code: 1193. Unknown system variable
26
ERROR 1006 (HY000) Can't create database (errno: 13) MySQL 5.6.12
0
php Aes_Encrypt Fatal Error
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.