next up previous contents
Next: Decryption Up: Encryption and decryption Previous: Encryption and decryption   Contents

Encryption

You can encrypt the ID, First_Name and Last_Name rows of the database you created without encryption.

To encrypt a database,

  1. Select the database you are going to encrypt in the table on the Create & Drop Database dialog.
  2. Click the Encrypt/Decrypt button. You will be prompted for confirmation.
  3. Click the OK button if you are sure to want to encrypt the database. Caution : Encryption of multi-byte characters is not supported. If you dare to do that, decryption will fail. Caution : In case of troubles that could happened with encryption, it is preferable to create a dump of the database before encrypt it. See Section 6.4 ([*] page) for the information on the SQL dump.
  4. You will be asked to select the algorithm of encryption. Choose bf (Blowfish) or aes (AES).
  5. You will be prompted for an encryption key. This key will be required whenever you are going to connect to the database. Caution : If you forget the key, you cannot decrypt the database forever.
  6. You will be informed that encryption is successful by the message line in the Create & Drop Database dialog,


next up previous contents
Next: Decryption Up: Encryption and decryption Previous: Encryption and decryption   Contents
manabu 2010-11-14