Encrypt entire MySQL db in Mac OS X 10.6

Posted on 2010-11-30
Medium Priority
Last Modified: 2012-05-10
I need to provide an encrypted database for a client on a Mac OS X 10.6.5 Mac Pro. I don't believe there will be any PHP or web front end for this data. It will just be queried directly using MySQL queries.

What is the best solution for encrypting an entire database?
Question by:MazarothIT
  • 2
LVL 53

Expert Comment

ID: 34243057

Author Comment

ID: 34244183
Thats true. It would require the users to mount the sparsebundle image before performing MySQL queries. I think I could teach them how...

I have a couple of concerns with that method though.

1. Would there be a problem with dismounting the sparsebundle while the MySQL service is running?
2. How much will MySQL performance be affected by the database being in an encrypted sparsebundle?
LVL 53

Accepted Solution

strung earned 2000 total points
ID: 34244568
I don't know enough about MySql to answer the first question.

My guess with respect to the second is that any delay will be in the initial opening and closing of the sparsebundle.

The only other option I can think of is FileVault but that can be problematical:


(file vault basically turns the whole Home folder into an encrypted sparsebundle)
LVL 27

Expert Comment

ID: 34690251
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question