数据加密

定义

  1. SHOW ENCRYPT RULES [FROM schemaName]
  3. SHOW ENCRYPT TABLE RULE tableName [from schemaName]
  • 支持查询所有的数据加密规则和指定逻辑表名查询

说明

列说明
table逻辑表名
logicColumn逻辑列名
cipherColumn密文列名
plainColumn明文列名
encryptorType加密算法类型
encryptorProps加密算法参数

示例

显示加密规则

  1. mysql> show encrypt rules from encrypt_db;
  2. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  3. | table     | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps          |
  4. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  5. | t_encrypt | order_id    | order_cipher | NULL        | MD5           |                         |
  6. | t_encrypt | user_id     | user_cipher  | user_plain  | AES           | aes-key-value=123456abc |
  7. | t_order   | item_id     | order_cipher | NULL        | MD5           |                         |
  8. | t_order   | order_id    | user_cipher  | user_plain  | AES           | aes-key-value=123456abc |
  9. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  10. 4 rows in set (0.01 sec)

显示加密表规则表名

  1. mysql> show encrypt table rule t_encrypt;
  2. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  3. | table     | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps          |
  4. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  5. | t_encrypt | order_id    | order_cipher | NULL        | MD5           |                         |
  6. | t_encrypt | user_id     | user_cipher  | user_plain  | AES           | aes-key-value=123456abc |
  7. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  8. 2 rows in set (0.00 sec)
  10. mysql> show encrypt table rule t_encrypt from encrypt_db;
  11. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  12. | table     | logicColumn | cipherColumn | plainColumn | encryptorType | encryptorProps          |
  13. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  14. | t_encrypt | order_id    | order_cipher | NULL        | MD5           |                         |
  15. | t_encrypt | user_id     | user_cipher  | user_plain  | AES           | aes-key-value=123456abc |
  16. +-----------+-------------+--------------+-------------+---------------+-------------------------+
  17. 2 rows in set (0.00 sec)