Topic: How to Encrypt MySQL Connection Information ?

Hello,

I use MySQL connection code from this link http://myvisualdatabase.com/forum/viewtopic.php?id=1804 (Russian Language)

Can encrypt the sensitive information ?
MySQLConnection.Server
MySQLConnection.Username
MySQLConnection.Password
MySQLConnection.Database

Life is like a school;
One can learn and graduate or stay behind.

2 (edited by brian.zaballa 2022-05-19 04:47:13)

Re: How to Encrypt MySQL Connection Information ?

Hi FMR,

You can use built-in encrypt function of MVD to do that but personally, I wouldn't do that for it would be a hell of work if you want to debug it.

My way of adding security to the information is by creating another form, then storing a label there to handle the sensitive info such as db, username, password etc. Something like this...

{$MySQL disable_connectdialog}
     Form1.MySQLConnection.Server := '127.0.0.1';
     Form1.MySQLConnection.Port := 3306;
     Form1.MySQLConnection.Username := SecretForm.Label1.Caption;
     Form1.MySQLConnection.Password := SecretForm.Label2.Caption;
     Form1.MySQLConnection.Database := SecretForm.Label3.Caption;

But if you really want an encrypted data, then this sample might help you

Post's attachments

Attachment icon InfoEncrypt.zip 548.92 kb, 120 downloads since 2022-05-19 

brian