mySql stored procs encryption

Question

I am looking into ways to encrypt mySQL stored procedure source code when installed in clients local environment.

I did lot of research on this topic and had no luck except for one promising reply from gazzang.com

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

We should be able to encrypt the table where store procs and functions are stored - mysql.proc Thus os users won't be able to read the contents of the sp or functions. I can't remember which internal table views are stored in but the same some apply to them. I am not sure we could come up with a solution to encrypt the routines internal to mysql. Other databases that do this really implement "obfuscation" internally - I think PostgreSQL does that for example.

@Pekka: your dupe suggestion is sql-server, this is MySQL. I don't think the syntax, parameters and inner workings are the same (especially for stuff like stored procs). — Konerak
– Konerak, Commented May 2, 2011 at 14:29
A better one:Can stored procedure in MySql 5.0.x be encrypted? — Pekka
– Pekka, Commented May 2, 2011 at 14:35
possible duplicate of Can stored procedure in MySql 5.0.x be encrypted? — Vladislav Rastrusny
– Vladislav Rastrusny, Commented May 2, 2011 at 15:10

Vladislav Rastrusny · Accepted Answer · 2011-05-02 15:09:55Z

1

You cannot encrypt stored procedures in a really useful way, because MySQL server will have to decrypt it anyway when it reads stored procedure from it's tables. If you encrypt the table file, your customer will login as root and make dump on mysql.proc table using native MySQL statements. If you change root password, they will always have a way to start MySQL with --skip-grant-tables switch to overcome that.

answered May 2, 2011 at 15:09

Vladislav Rastrusny

30.2k23 gold badges100 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ali Over a year ago

Is there any other means of encrypting mySql stored procedures in current version?

Collectives™ on Stack Overflow

mySql stored procs encryption

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related