0

I have certain information being stored in a MySQL database that warrants being stored in an encrypted form. However my .Net application can't absorb the perfomance hit of doing the encryption and decryption at the application layer.

Is there any MySQL function that allows an ecryption key to be specified in the connection string and then have the MySQL database do the encrption operations?

Improve this question

1 Answer 1

Reset to default
1

do you mean

AES_ENCRYPT

and

AES_DECRYPT

you can pass the key when you run the query

you can see an example

EDIT:

another option to use

DES_ENCRYPT() and DES_DECRYPT()

The key file can be specified with the --des-key-file server option

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

1 Comment

That pointed me in the right dirn. What I actually want is Transparent Data Encryption (en.wikipedia.org/wiki/Transparent_Data_Encryption). But appears I'm out of luck with MySQL unless I want to purchase a commercial product at $50/month!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.