Encrypt MariaDB Data

Post Reply
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Encrypt MariaDB Data

Post by Otto »

Hello,

From the MariaDB web page

https://mariadb.com/kb/en/library/why-e ... iadb-data/
Nearly everyone owns data of immense value: customer data, construction plans, recipes, product designs and other information. These data are stored in clear text on your storage media. Everyone with file system access is able to read and modify the data. If this data falls into the wrong hands (criminals or competitors) this may result in serious consequences.

With encryption you protect Data At Rest (see the Wikipedia article). That way, the database files are protected against unauthorized access.

BTW XAMPP is installing MariaDB by default.

Does someone of you have experience with setting up rest-data encryption and MariaDB.
Best regards
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org

********************************************************************
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: Encrypt MariaDB Data

Post by fraxzi »

Thank you Otto,

I am planning to do encryption on my current project too.. This is a good start to initially understand it .

:wink:
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Re: Encrypt MariaDB Data

Post by Otto »

Hello,
with encryption on my database files look like this. Now I feel relaxed.
Best regards
Otto
Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org

********************************************************************
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: Encrypt MariaDB Data

Post by fraxzi »

Hello Otto,

What are the steps you made? could you share ...

:wink:
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Re: Encrypt MariaDB Data

Post by Otto »

Hello Frances,
I am sorry but I didn't setup the server myself.
Now we have working 64 bit version of Apache and MariaDB.
Both as a services.
Now I have to find a way how to secure the key file.
It seems you only need the file at the start of MariaDB.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org

********************************************************************
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Re: Encrypt MariaDB Data

Post by Otto »

https://blog.avira.com/a1-telekom-austr ... lain-text/

Hello,
usually you are not personally affected. But in this case I have a little member web page with this company too.
Only a landing page.
But that shows again the importance of "encryption at rest" .
Best regard,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org

********************************************************************
Post Reply