encryption
What's the best way to encrypt entire DB's using HeidiSQL?
You can encrypt column by column, e.g. by inserting row values with a ENCODE('string value', 'secretpassword'), but that requires you to DECODE() all these values at runtime.
You should not do that. Instead, make the database readable only for specific users. Set up other users so that they cannot select something from that db. And use a cryptic, long password for users which can access that db.
You should not do that. Instead, make the database readable only for specific users. Set up other users so that they cannot select something from that db. And use a cryptic, long password for users which can access that db.
No, not that I knew of, at least not via SQL. You can of course encrypt the files on the servers filesystem with some external application.
Hell, you should of course take care nobody is able to do that. The server files should be privileged to some specific user + MySQL itself, nothing more. If you do so, nobody should be able to steal or delete your data.
in case someone does pull the files
Hell, you should of course take care nobody is able to do that. The server files should be privileged to some specific user + MySQL itself, nothing more. If you do so, nobody should be able to steal or delete your data.
Please login to leave a reply, or register at first.