How to ENCRYPT/DECRYPT columns in MySql comfortably?

Board index FiveWin for Harbour/xHarbour How to ENCRYPT/DECRYPT columns in MySql comfortably?

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

How to ENCRYPT/DECRYPT columns in MySql comfortably?
Posted: Sat Jul 21, 2018 09:33 AM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

Baxajaun

Posts: 990

Joined: Wed Oct 19, 2005 02:17 PM

Re: How to ENCRYPT/DECRYPT columns in MySql comfortably?
Posted: Sat Jul 21, 2018 10:54 AM

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

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: How to ENCRYPT/DECRYPT columns in MySql comfortably?
Posted: Sun Jul 22, 2018 09:46 AM

Dear Baxajaun,

Thank you so much, I will try.

Baxajaun wrote: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,

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

FiveTech Support Forums

Continue the discussion