Encrypt querys mysql

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Wed 18 Dec 2019 14:15

Encrypt querys mysql

Post by weslleysolo » Wed 18 Dec 2019 14:24

Hello, I have a Delphi application and want to know how to encrypt my querys. The application runs on a local server.


Code: Select all

SELECT administracaoxitemxprescricao.CD_USUARIO, administracaoxitemxprescricao.DS_DIA, administracaoxitemxprescricao.DS_HORA,
 administracaoxitemxprescricao.DT_DATA, year(prescricoes.DT_PRESCRICAO) as data_prescricao
 FROM administracaoxitemxprescricao 
 join prescricoes ON prescricoes.CD_PRESCRICAO = administracaoxitemxprescricao.CD_PRESCRICAO
 WHERE administracaoxitemxprescricao.CD_USUARIO = 1 

Devart Team
Posts: 2887
Joined: Wed 30 Jul 2014 07:16

Re: Encrypt querys mysql

Post by ViktorV » Fri 20 Dec 2019 10:49

To protect your data, you can use data encryption. MyDAC supports data encryption using the TMyEncryptor component. Take into account, that this component is available only in Professional and Trial Editions. See more details about data encryption in the MyDAC documentation: https://www.devart.com/mydac/docs/encryption.htm

Post Reply