Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6078

[DOC] verify encryption page has invalid query/info

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.18-9
    • Component/s: Documentation
    • Labels:
      None

      Description

      This page here:
      https://www.percona.com/doc/percona-server/8.0/security/verifying-encryption.html#verifying-encryption

      has this:

      To identify schemas with encryption enabled, run the following query:
      
      mysql> SELECT schema_name, default_encryption FROM INFORMATION_SCHEMA WHERE
      DEFAULT_ENCRYPTION='YES';
      
      +---------------+-----------------------------+
      | schema_name   | default_encryption          |
      +---------------+-----------------------------+
      | sample        | YES                         |
      +---------------+-----------------------------+
      

      and then this:

      To identify schemas which are encryption-enabled, you can query the INFORMATION_SCHEMA.SCHEMATA table:
      
      mysql> SELECT SCHEMA_NAME, DEFAULT_ENCRYPTION FROM
      INFORMATION_SCHEMA.SCHEMATA WHERE DEFAULT_ENCRYPTION='YES';
      
      +------------------------------+---------------------------------+
      | SCHEMA_NAME                  | DEFAULT_ENCRYPTION              |
      +------------------------------+---------------------------------+
      | samples                      | YES                             |
      +------------------------------+---------------------------------+
      

      Looks like those two blocks should be the same thing, but the example in first block doesn't work - so I assume this was added twice by error. Second block seems fine to me.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                patrick.birch Patrick Birch
                Reporter:
                tomislav.plavcic@percona.com Tomislav Plavcic
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 hour, 10 minutes
                  1h 10m