SONAME ’data_masking.so’; CREATE FUNCTION mask_inner RETURNS STRING SONAME ’data_masking.so’; CREATE FUNCTION mask_outer RETURNS STRING SONAME ’data_masking.so’; CREATE FUNCTION mask_pan RETURNS STRING SONAME ’data_masking.so’; CREATE FUNCTION mask_pan_relaxed RETURNS STRING SONAME ’data_masking.so’; CREATE FUNCTION mask_ssn RETURNS STRING SONAME ’data_masking.so’; 

If the plugin and functions are used on a replication source server, install them on all replica servers as well to avoid replication issues. 

Once installed as just described, the plugin and functions remain installed until uninstalled. To remove them, use the UNINSTALL PLUGIN  and DROP FUNCTION  statements: 

UNINSTALL PLUGIN data_masking; DROP FUNCTION gen_blocklist; DROP FUNCTION gen_dictionary; DROP FUNCTION gen_dictionary_drop; DROP FUNCTION gen_dictionary_load; DROP FUNCTION gen_range; DROP FUNCTION gen_rnd_email; DROP FUNCTION gen_rnd_pan; DROP FUNCTION gen_rnd_ssn; DROP FUNCTION gen_rnd_us_phone; DROP FUNCTION mask_inner; DROP FUNCTION mask_outer; DROP FUNCTION mask_pan; DROP FUNCTION mask_pan_relaxed; DROP FUNCTION mask_ssn; 

## 6.5.3 Using MySQL Enterprise Data Masking and De-Identification 

Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and De- Identification” . 

To use MySQL Enterprise Data Masking and De-Identification in applications, invoke the functions that are appropriate for the operations you wish to perform. For detailed function descriptions, see Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions” . This section demonstrates how to use the functions to carry out some representative tasks. It first presents an overview of the available functions, followed by some examples of how the functions might be used in real-world context: 

## Masking Data to Remove Identifying Characteristics 

•Masking Data to Remove Identifying Characteristics 

•Generating Random Data with Specific Characteristics 

•Generating Random Data Using Dictionaries 

•Using Masked Data for Customer Identification 

•Creating Views that Display Masked Data 

MySQL provides general-purpose masking functions that mask arbitrary strings, and special-purpose masking functions that mask specific types of values. 

