Geek asks and answers

MySql stores procs encryption

I am exploring ways to encrypt the source code of a mySQL stored procedure when installed in a local client environment.

I have researched this subject a lot and no luck except one promising answer from gazzang.com

Here is the answer from gazzang. Let me know if someone has already tried this.

We should be able to encrypt the table in which procs and storage functions are stored - mysql.proc Thus, users will not be able to read the contents of sp or functions. I can’t remember which internal views of the table are stored, but they are the same. I'm not sure that we could come up with a solution to encrypt internal procedures for mysql. Other databases that do this do implement “obfuscation” internally - I think PostgreSQL does this, for example.

+3
source share
1 answer

You cannot encrypt stored procedures in a really useful way, because the MySQL server will have to decrypt it anyway when it reads the stored procedure from it. If you encrypt the table file, your client will log in as the root user and dump the mysql.proc table using its own MySQL instructions. If you change the root password, they will always be able to start MySQL with the -skip-grant-tables switch to overcome this.

0
source

More articles:


All Articles