Comments - database password?

9 years, 10 months ago Vladislav Vaintroub

You can restrict access to the data directory only to specific OS user or group, using usual OS means. You would need to run mysqld service under the same user. Don't give untrused people administrator level access to the box (so they can change the ACL), then you should be fine without encryption. "Someone" would not be able to copy files unless he has read access to the files.

9 years, 10 months ago Vladislav Vaintroub

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.

seems to be related to your question.

9 years, 10 months ago Vladislav Vaintroub

Also, passwords are not stored in the DBMS. No idea where you have this information from.. Password hashes are stored, yes, but you (or anyone else) will have hard times retrieving clear password from hash.

9 years, 10 months ago Thomas Gessl
-) sure, hashes, yes... Sorry, I would describe only the users point of view, not technical internals.

Thank you for your help. I see, there is no easy answer for this and I have to use additional (OS-specific) solutions.

I was unsure whether there is a feature like MS-SQL TDE (transparent data encryption) and only I missed it. Therefore my question.

Thank you for your fast response. This forum and your work is of precious help.

Best regards, Thomas

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.