如何保护数据库文件免于在 Windows 中复制 [英] How To Protect Database Files From Copying In Windows

问题描述

我正在使用 PHP + MySQL 开发一个项目并将其安装到我客户端的 Windows 服务器上.在我的应用程序数据库中会有一些机密信息.复制位于 mysql 下数据目录中的数据库文件夹并将其粘贴到任何 mysql 服务器并进行修改非常容易.(在窗口中).

I am developing a project with PHP + MySQL and install it to my client's windows server. In my app database there will be some confidential info. Its very easy to copy the database folder located in data directory under mysql and paste it to any mysql server and modify that. (in windows).

如何保护我的数据库免受该操作的影响?

How can I protect my database from that action?

推荐答案

这似乎有点明显所以它可能不是您期望的答案，但为什么不简单地设置目录权限，以便只有 mysql 下的用户服务器运行可以读/写吗?

This seems a bit obvious so it might not be the answer you expect, but why not simply set up the directory permissions so that only the user under which the mysql server runs can read/write in it?

当然，在该计算机上拥有管理员帐户的人仍然可以访问它，但我不知道您如何避免这种情况.

Of course someone with an admin account on that computer will still be able to access it, but then I don't see how you could avoid that.

这篇关于如何保护数据库文件免于在 Windows 中复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！