Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
Man Pages (TGZ) - 259.3Kb
Man Pages (Zip) - 366.4Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


29.12.18.2 The keyring_keys table

MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. See Section 8.4.4, “The MySQL Keyring”.

The keyring_keys table exposes metadata for keys in the keyring. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose any sensitive keyring data such as key contents.

The keyring_keys table has these columns:

  • KEY_ID

    The key identifier.

  • KEY_OWNER

    The owner of the key.

  • BACKEND_KEY_ID

    The ID used for the key by the keyring backend.

The keyring_keys table has no indexes.

TRUNCATE TABLE is not permitted for the keyring_keys table.