How to ENCRYPT/DECRYPT columns in MySql comfortably?

[dutch]

Dear All,

I have a columns (Credit Card) in MySql table. I need to encrypt this columns.

How do I encrypt and decrypt it comfortably?

Thanks in advance for any idea and suggestion.

[Baxajaun]

Hi Dutch,

please, review https://mariadb.com/kb/en/library/aes_encrypt/

http://www.johnboy.com/blog/how-to-use-mysqls-aes_encrypt-and-aes_decrypt-to-store-information-in-a-database

Best regards,

[dutch]

Dear Baxajaun,

Thank you so much, I will try.

Hi Dutch,

please, review https://mariadb.com/kb/en/library/aes_encrypt/

http://www.johnboy.com/blog/how-to-use-mysqls-aes_encrypt-and-aes_decrypt-to-store-information-in-a-database

Best regards,