Using MySQL Enterprise Data Masking and De-Identification mysql>  SELECT gen_rnd_ssn(); +---------------+ | gen_rnd_ssn() | +---------------+ | 912-45-1615 | +---------------+ mysql>  SELECT gen_rnd_us_phone(); +--------------------+ | gen_rnd_us_phone() | +--------------------+ | 1-555-747-5627 | +--------------------+ Berlin Munich Bremen Chicago Houston Phoenix El Paso Detroit mysql>  SELECT gen_dictionary_load(’/usr/local/mysql/mysql-files/de_cities.txt’, ’DE_Cities’); +--------------------------------------------------------------------------------+ | gen_dictionary_load(’/usr/local/mysql/mysql-files/de_cities.txt’, ’DE_Cities’) | +--------------------------------------------------------------------------------+ | Dictionary load success | +--------------------------------------------------------------------------------+ mysql>  SELECT gen_dictionary_load(’/usr/local/mysql/mysql-files/us_cities.txt’, ’US_Cities’); +--------------------------------------------------------------------------------+ | gen_dictionary_load(’/usr/local/mysql/mysql-files/us_cities.txt’, ’US_Cities’) | +--------------------------------------------------------------------------------+ | Dictionary load success | +--------------------------------------------------------------------------------+ 1580 Assume that the  secure_file_priv  system variable is set to  /usr/local/mysql/mysql-files . In that case, copy the dictionary files to that directory so that the MySQL server can access them. Then use gen_dictionary_load()  to load the dictionaries into the dictionary registry and assign them names: Also suppose that a file named  us_cities.txt  contains these city names in the United States: Suppose that a file named  de_cities.txt  contains these city names in Germany: MySQL Enterprise Data Masking and De-Identification enables dictionaries to be used as sources of random values. To use a dictionary, it must first be loaded from a file and given a name. Each loaded dictionary becomes part of the dictionary registry. Items then can be selected from registered dictionaries and used as random values or as replacements for other values. A valid dictionary file has these characteristics: Generating Random Data Using Dictionaries gen_rnd_us_phone()  returns a random US phone number in the 555 area code not used for legitimate numbers: •The file must contain at least one term. •Empty lines are ignored. •The file contents are plain text, one term per line.