encrypt data
Dear Friends is their any way to encrypt data saved to an mysql server? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: encrypt data
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html Luiz Rafael Culik Guimaraes wrote: Dear Friends is their any way to encrypt data saved to an mysql server? Regards Luiz -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: encrypt data
Also, do you know if there is any way at all to do the tiniest amount of research on my own to find out even the most basic information about MySQL without bothering an entire worldwide mailing list with my trivial questions?
Re: encrypt data
Jake Peavy [EMAIL PROTECTED] wrote on 11/26/2005 07:54:22 PM: Also, do you know if there is any way at all to do the tiniest amount of research on my own to find out even the most basic information about MySQL without bothering an entire worldwide mailing list with my trivial questions? RTFM? http://dev.mysql.com/doc/ Search the archives of the mailing list? http://lists.mysql.com/ Search the forums? http://forums.mysql.com/ STFW? http://www.yahoo.com/ http://www.google.com/ http://www.msn.com/ The research is easy as all of these sources have search features. If you come to an actual question that you could not answer from any of these sources, you are most welcome to bother us. I think we all remember what it's like to be newbies and most of us didn't have the web or emails or much else to rely on to learn from. We are happy to help but we do hope for a minimum of effort from the person asking the questiono to find the answer on their own first. Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for life. (Chinese proverb) We give away a lot of fish on this list but I think most of us try to teach as we go. See you soon! Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Encrypt data
hi, Mike. What do this using an encrypted loopback-device, on which the /var/lib/mysql stuff resides. just check man losetup for instructions. i'm NOT sure about the preformance issues, though. and i am very concerned about filesystem-corruptionby my logic, there's a double risk, since the host fs and the loopback-fs could be damaged. and just imagine a eeny little tiny error in the host file. as far as i can judge, that would completely screw up the whole partitition.but i'd be VERY happy to be corrected on that. (little hint: i store the passphrase on a floppy that has to be inserted on boot. a little script reads it and mounts the loopback before kicking of mysqld. the floppy is thereafter removed and stored safely) cheers and HTH, M. Mike Koponick wrote: Hello everyone, I'm new to the list and did a little searching on the archives but wanted to ask my question to the group. I have a requirement to encrypt all data stored into a database. I was wondering if there was a different way of doing this or should I use the encrypt/decrypt functions? The idea is that if someone stole the hard drive or computer, it would be hard for someone to break into the database. It seems to me the best way would be to encrypt the drive space, and use the login to authenticate the encryption space on the hard drive. Is something like this doable? I'm running a server with RedHat 9.0/MySQL version 4.0.16. Thanks in advance, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Encrypt data
Hello everyone, I'm new to the list and did a little searching on the archives but wanted to ask my question to the group. I have a requirement to encrypt all data stored into a database. I was wondering if there was a different way of doing this or should I use the encrypt/decrypt functions? The idea is that if someone stole the hard drive or computer, it would be hard for someone to break into the database. It seems to me the best way would be to encrypt the drive space, and use the login to authenticate the encryption space on the hard drive. Is something like this doable? I'm running a server with RedHat 9.0/MySQL version 4.0.16. Thanks in advance, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Encrypt data
Mike Koponick wrote: The idea is that if someone stole the hard drive or computer, it would be hard for someone to break into the database. It seems to me the best way would be to encrypt the drive space, and use the login to authenticate the encryption space on the hard drive. How about sth like that: http://freshmeat.net/projects/cryptofs/ Nothing mysql-specific though, and I know nothing about its speed or usability in general. But maybe you want to give it a try. Greets Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]