+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Encrypt decrypt table on Mysql (/showthread.php?tid=70606)
Encrypt decrypt table on Mysql - alessiome - 05-03-2018
Hi All,
I'm going to set up all Codeigniter sites to be compliance with GDPR.
In order to increase the security of personal data I'm thinking to encrypt the table "users".
Do you know if there are some methods on CI to do that?
I know about Encryption Library but I don't know if there are some methods to encrypt and decrypt data from and to DB (Example using database features...)
Thank you
Best regards
Alessiome
RE: Encrypt decrypt table on Mysql - InsiteFX - 05-03-2018
This is how some people do it.
ENCRYPT MYSQL DATA USING AES TECHNIQUES
Hope that helps.
RE: Encrypt decrypt table on Mysql - Paradinight - 05-03-2018
(05-03-2018, 05:47 AM)alessiome Wrote: Hi All,
I'm going to set up all Codeigniter sites to be compliance with GDPR.
In order to increase the security of personal data I'm thinking to encrypt the table "users".
Do you know if there are some methods on CI to do that?
I know about Encryption Library but I don't know if there are some methods to encrypt and decrypt data from and to DB (Example using database features...)
Thank you
Best regards
Alessiome
https://paragonie.com/blog/2017/05/building-searchable-encrypted-databases-with-php-and-sql
RE: Encrypt decrypt table on Mysql - InsiteFX - 05-03-2018
@ Paradinight,
Darn I forgot about that one, shame on me...
RE: Encrypt decrypt table on Mysql - skunkbad - 05-10-2018
I don't really have a lot of EU users. For my own GDPR compliance, which mostly revolves around Google Analytics usage, I just use a geo-ip service and skip embedding the GA code for countries in the EU. I find it interesting that there seems to be a full GDPR panic mode going on right now. Logged into Mailchimp today and they had a special message that customer service was overwhelmed with GDPR questions. Reading #GDPR on twitter is pretty interesting
