1 Replies - 669 Views - Last Post: 16 April 2012 - 05:46 AM

#1 jastig  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 15-March 12

encryption and decryption

Posted 16 April 2012 - 04:28 AM

hi friends,we all know that we can encrypt a single column by using aes...my doubt is can we encrypt and decrypt complete sql table using aes encrypt and decrypt and how? and also can we encrypt and decrypt complete database using aes....waiting for your help. :helpsmilie: ..thanks in advance... :dontgetit:

Is This A Good Question/Topic? 0
  • +

Replies To: encryption and decryption

#2 Atli  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 3719
  • View blog
  • Posts: 5,990
  • Joined: 08-June 10

Re: encryption and decryption

Posted 16 April 2012 - 05:46 AM

Hey.

As far as I am aware you can not encrypt entire tables or databases in MySQL. The CREATE TABLE syntax lists a "PASSWORD" table option, but it says that it's unused.

The best option I can think to try is to put the data files themselves on an encrypted drive. I've not attempted this myself, but I can't see why that wouldn't work.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1