Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
None
-
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.
