• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Encrypt decrypt table on Mysql

#1
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
Reply

#2
This is how some people do it.

ENCRYPT MYSQL DATA USING AES TECHNIQUES

Hope that helps.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#3
(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/build...hp-and-sql
Reply

#4
@ Paradinight,

Darn I forgot about that one, shame on me...
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#5
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 Smile
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.