数据加密

定义

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

说明

列说明
table逻辑表名
logic_column逻辑列名
cipher_column密文列名
plain_column明文列名
encryptor_type加密算法类型
encryptor_props加密算法参数

示例

显示加密规则

  1. mysql> show encrypt rules from encrypt_db;
  2. +-----------+--------------+---------------+--------------+----------------+-------------------------+
  3. | table     | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props         |
  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     | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props         |
  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     | logic_column | cipher_column | plain_column | encryptor_type | encryptor_props         |
  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)