MySQL and data file encryption

Question

Is there a way to encrypt the data file that mysql uses? I have a mysql server on an open machine, and I would like to encrypt the data file so even if someone copies the data files, they cannot read the data.

Thanks

Dustin Kirkland · Accepted Answer · 2012-03-14 01:01:47Z

6

To anyone researching a transparent MySQL encryption solution for Linux, there's a relatively new product on the block that we've been working with: http://www.gazzang.com/

I am not affiliated with Gazzang... just a happy customer.

edited Mar 14, 2012 at 1:01

Dustin Kirkland

5,5433 gold badges41 silver badges35 bronze badges

answered Oct 12, 2009 at 0:10

Trae

6671 gold badge10 silver badges22 bronze badges

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

1 Comment

Basic Over a year ago

I've used it and it's good but a little over-priced for what we need

dimus · Accepted Answer · 2008-09-28 21:36:57Z

5

I am not sure what do you mean when you say that your machine is open. If people have access to the console, or to your account it is much harder of a task to encrypt the file.

Did you look at Truecrypt? It works for most popular operating systems and allows to create a virtual encrypted partition, lock down a hard drive partition,an external drive or a usb device.

answered Sep 28, 2008 at 21:36

dimus

9,50011 gold badges50 silver badges57 bronze badges

Comments

Kev · Accepted Answer · 2008-09-27 15:31:35Z

5

MySQL doesn't support data file encryption natively. There are 3rd products out there such as:

http://www.vormetric.com/products/vormetric_database_encryption_expert.html

There's a 'white paper' on the topic here:

http://www.vormetric.com/documents/FINALPart2DatabaseEncryptionCoreGuardvsColumnLevelWhitePaper7.pdf

To be honest, if the database content has any commercial value or contains personal data about individuals, you should really control who has access to the datafiles (whether encrypted or not). In the UK, leaving such data files open to casual passers-by, would be a data protection no no.

answered Sep 27, 2008 at 15:31

Kev

120k53 gold badges308 silver badges396 bronze badges

1 Comment

Kris Over a year ago

Not just in the UK, that's a universal no-no and probably beyond.

Vinko Vrsalovic · Accepted Answer · 2008-09-27 15:30:40Z

0

You can use an encrypted filesystem, like the native one for NTFS on Windows or one of the various options for linux. In addition you can store the data encrypted.

answered Sep 27, 2008 at 15:30

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

Comments

Khamyl · Accepted Answer · 2014-02-18 06:42:27Z

0

If you are using windows EFS and starting MySQL as a service, you will need to do the following:

go to Services and find the MySQL service
stop the service
right-click -> properties -> LogON TAB
check "This account"
fill your windows account name eg. ".\username"
provide your password
start the service

The MySQL service should now start without errors.

To use the windows EFS encryption:

http://windows.microsoft.com/en-us/windows/encrypt-decrypt-folder-file#1TC=windows-7

Comments

J.J. · Accepted Answer · 2008-09-27 15:00:54Z

-2

you could encrypt the data within mysql using the built in encryption functionality.

as for the files, any file solution should work fine.

answered Sep 27, 2008 at 15:00

J.J.

4,8901 gold badge27 silver badges29 bronze badges

Collectives™ on Stack Overflow

MySQL and data file encryption

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related