Install the data masking component¶

The component has the following parts:

A database server system table used to store the terms and dictionaries
A component_masking_functions component that contains the loadable functions

The MASKING_DICTIONARIES_ADMIN privilege may be required by some functions.

Install the component¶

The following steps install the component:

Create masking_dictionaries.

mysql> CREATE TABLE IF NOT EXISTS
mysql.masking_dictionaries(
    Dictionary VARCHAR(256) NOT NULL,
    Term VARCHAR(256) NOT NULL,
    UNIQUE INDEX dictionary_term_idx (Dictionary, Term)
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4;

Install the data masking components and the loadable functions.

mysql> INSTALL COMPONENT 'file://component_masking_functions';

The MASKING_DICTIONARIES_ADMIN is required to use the the following functions:
- masking_dictionary_term_add
- masking_dictionary_term_remove
- masking_dictionary_remove
```
mysql> GRANT MASKING_DICTIONARIES_ADMIN ON *.* TO <user>;
```

Useful links¶

Uninstall the data masking component

Data masking component functions

Last update: 2023-10-04