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

[DOC] verify encryption page has invalid query/info

    XMLWordPrintable

    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.

        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

                  Smart Checklist