The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

database password?

Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data.

We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client?

Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc.

Thank you in advance. Best regards, Thomas

Env: WinXP, Win7, Win8

Answer Answered by Vladislav Vaintroub in this comment.

Also, there is copious information available on encrypted file system or EFS - you're running on Windows, so you're probably lucky in that you can use FS encryption that comes out-of-the-box.

http://stackoverflow.com/questions/14405356/how-to-encrypt-a-directory-with-application-specific-keys

seems to be related to your question.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.