crypt mysql

[benjamin.dorleans]

Hello everybody,

I'd like to know if there is a way to crypt data in Mysql, to protect my customers.

Thanks

[Angel]

There is a way, but the amount of work involved in doing so will vary, depending on how you choose to go about it.

For example, you could use AES to encrypt the data, but that also means you'll have to modify a ton of Sugar PHP code to encrypt/decrypt the data, so unless you have a lot of time on your hands, it is probably not a working solution.

An alternative method would be to encrypt the MySQL data folder at the filesystem level (i.e. through Windows). I would assume you'd be able to do something similar on Linux too.

There are some pointers on both approaches here:

http://dev.mysql.com/doc/refman/5.0/...functions.html

http://dev.mysql.com/tech-resources/...l_windows.html

[benjamin.dorleans]

thanks a lot angel, i'm gonna propose both solutions to my manager

[ruchida]

Hi

This is another option.

[SteveOa]

Security-GENERAL from Packet GENERAL Networks is what you are looking for.

Security-GENERAL is industry's first secure server appliance for MySQL. Security-GENERAL offers data security for critical MySQL data of your organization through transparent and always-on encryption, strong key management, role based access control and audit logs. Security-GENERAL also facilitates you to take encrypted backups of MySQL data.

Security-GENERAL provides regulatory compliance with the information disclosure laws and the PCI mandates.