Guest User

Untitled

a guest
Dec 10th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. mkdir /etc/mysql/
  2. openssl rand -hex 16 >> /etc/mysql/keys.txt
  3. openssl rand -hex 16 >> /etc/mysql/keys.txt
  4. openssl rand -hex 16 >> /etc/mysql/keys.txt
  5. vi /etc/mysql/keys.txt // Here I add "1;", "2;" and "3;"
  6. openssl enc -aes-256-cbc -md sha1 -k MY_PASSWORD_HERE -in /etc/mysql/keys.txt -out /etc/mysql/keys.enc
  7. vi /etc/my.cnf
  8.  
  9. I add these lines :
  10. [mariadb]
  11. innodb-encrypt-tables
  12. innodb-encrypt-log
  13. innodb-encryption-threads = 4
  14. plugin-load-add=file_key_management
  15. file_key_management_filename=/etc/mysql/keys.txt
  16. file_key_management_encryption_algorithm=AES_CTR
  17. # for monitoring
  18. innodb-tablespaces-encryption
  19.  
  20. service mysql restart
Add Comment
Please, Sign In to add comment