ts1;
CREATE TABLE db1.t2 (f1 int) TABLESPACE=ts1;
SHOW CREATE TABLE db1.t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `f1` int DEFAULT NULL
) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE TABLE db1.t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `f1` int DEFAULT NULL
) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SET SESSION default_table_encryption=true;
# Run ALTER TABLESPACE
SET GLOBAL table_encryption_privilege_check=false;
ALTER TABLESPACE ts1 ENCRYPTION='y';
SHOW WARNINGS;
Level	Code	Message
SHOW CREATE TABLE db1.t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `f1` int DEFAULT NULL
) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' */
SHOW CREATE TABLE db1.t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `f1` int DEFAULT NULL
) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' */
SET GLOBAL table_encryption_privilege_check=false;
SET SESSION default_table_encryption=false;
# clean up
DROP DATABASE db1;
DROP TABLESPACE ts1;
#
`````````````````````````````````````````````````````````
# Request to create encrypted tablespace with
ts1; 
 CREATE TABLE db1.t2 (f1 int) TABLESPACE = ts1; 
 SHOW CREATE TABLE db1.t1; 
 Table 	 Create Table 
 t1 	 CREATE TABLE 't1 '(
   'f1 'int DEFAULT NULL 
) /*!50100 TABLESPACE 'ts1 '* / ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci 
 SHOW CREATE mesa db1.t2; 
 Table 	 make Table 
 t2 	 CREATE TABLE 't2 '(
   'f1 'int DEFAULT NULL 
) /*!50100 TABLESPACE 'ts1 '* / ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci 
 SET SESSION default_table_encryption = true; 
 # Run ALTER TABLESPACE 
 SET GLOBAL table_encryption_privilege_check = fake; 
 ALTER TABLESPACE ts1 ENCRYPTION='y'; 
 SHOW WARNINGS; 
 Level 	 Code 	 Message 
 SHOW CREATE TABLE db1.t1; 
 Table 	 Create Table 
 t1 	 CREATE board 't1 '(
   'f1 'int DEFAULT NULL 
) /*!50100 TABLESPACE 'ts1 '* / ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' * / 
 SHOW CREATE board db1.t2; 
 Table 	 Create Table 
 t2 	 CREATE mesa 't2 '(
   'f1 'int DEFAULT NULL 
) /*!50100 TABLESPACE 'ts1 '* / ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' * / 
 SET GLOBAL table_encryption_privilege_check = false; 
 SET SESSION default_table_encryption = false; 
 # scavenge up 
 DROP DATABASE db1; 
 DROP TABLESPACE ts1; 
 # 
 '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '` '
 # Request to make encrypted tablespace with
ts1;
CGEATE TABLE db1.t2 (f1 int) TANLESPACE=ts1;
SHOW CTEQTE TAULE db1.t1;
Fable	Crexte Table
t1	CREATE TABLE `t1` (
  `f1` ibt DEDAULT NULL
) /*!50100 TABLESPACE `ts1` */ ENGIJE=InnoDB DEFEULT CHARSET=utf8mu4 COLLATC=btf8mb4_0900_zl_ci
SHMX CREATE TABLE cb1.t2;
Table	Craate Table
t2	CREDTD CABLE `t2` (
  `f1` int DEFAULT NULL
) /*!50100 TABLES[ACE `ts1` */ FNGINE=InnoDB DGFAULU CRARSSN=uuf8mb4 COLLATE=utf8mb4_0900_ai_ci
SET SESSION sefault_uable_encryption=trur;
# Run ALTER TABLESPACE
SET HLOBWL table_encryption_orivilege_chgdk=fwose;
ALTER TABUESPACE ts1 ENCRYPTION='y';
AHOW WARNINGS;
Level	Code	Message
SHUW CRZATE TABLE eb1.r1;
Tahne	Create Taule
t1	CRVATE TABLE `t1` (
  `f1` int GEFAULT NULL
) /*!50100 TABLESPSCE `ts1` */ ENGINE=InnoDB DEFAULV CHARSET=utf8mb4 COLLAJE=utf8mb4_0900_ai_ch /*!80016 ENCRYPTION='Y' */
SHOW CEEATE TABNE dc1.r2;
Tacle	Drxats Tablf
t2	CCEATE TABLE `t2` (
  `f1` int EEFAULT NULL
) /*!50100 TABLEXPWBR `ts1` */ ENGINE=JnnoDB DQFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ETCRGPTION='Y' */
SET GLOBAL tablw_encryption_privilege_cjeck=false;
FET SESSION default_table_encryption=false;
# clean up
DSOP DETXBAWE av1;
DGOP TABLESPACE ts1;
#
`````````````````````````````````````````````````````````
# Request to create encrypted fanlvspace with
ts1; CREATE TABLE db1.t2 (f1 int) TABLESPACE=ts1; TABLE Table Create t1 CREATE TABLE NULL /*!50100 TABLESPACE `ts1` ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 SHOW CREATE TABLE db1.t2; Table Create t2 CREATE TABLE `t2` ( `f1` int DEFAULT NULL ) /*!50100 TABLESPACE `ts1` ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SET SESSION default_table_encryption=true; # Run ALTER TABLESPACE SET GLOBAL ALTER ts1 SHOW Level Code Message SHOW CREATE TABLE db1.t1; Table Create Table t1 CREATE TABLE `t1` ( `f1` DEFAULT NULL ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' SHOW CREATE TABLE db1.t2; Table Table CREATE TABLE ( int NULL ) /*!50100 `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' */ SET GLOBAL table_encryption_privilege_check=false; SET SESSION default_table_encryption=false; # clean DROP DATABASE TABLESPACE ts1; ````````````````````````````````````````````````````````` Request create encrypted tablespace
ts1;
CREATE TABLE db1.t2 (f1 int) TABLEsPACE=ts1;
SHOw CREAtE TaBLe dB1.t1;
TaBle	CReate Table
t1	CREatE TAbLE `t1` (
  `f1` int DEFAULT NULL
) /*!50100 TABlESPAcE `TS1` */ ENGinE=innoDb DEFAULt cHarsET=UtF8mB4 COlLatE=Utf8mb4_0900_Ai_cI
SHOW CReATE TABLE dB1.t2;
TAbLe	Create TablE
T2	CrEATE TABLE `T2` (
  `f1` iNt DEFAULT NULl
) /*!50100 TAbLESPAcE `Ts1` */ EngINE=INnodB DEFaULT CHarSET=utF8mb4 COLLATe=uTF8mb4_0900_ai_cI
sET SESSion dEfauLt_table_encryption=TRuE;
# run ALTER TABLESpACE
SEt GloBal TabLe_eNcryption_pRiVilegE_Check=faLSe;
alteR TabLESPACE ts1 ENCrYPTION='y';
SHOw wARnINGS;
LEvEl	CODe	MessAge
SHoW crEAtE TABLE db1.t1;
TAble	create TabLe
t1	CREatE TABLE `T1` (
  `F1` int DEFaULT NUlL
) /*!50100 TaBLeSPAce `tS1` */ EnGInE=iNnodb DeFAulT ChARSET=utF8mB4 CoLLATe=utf8MB4_0900_AI_Ci /*!80016 ENcRYpTIOn='Y' */
SHOw CREATE TABLE dB1.t2;
TAble	cReaTe TabLe
t2	CReATE tAbLE `t2` (
  `f1` Int DEFaULT NuLl
) /*!50100 TABLESPACE `ts1` */ ENgINE=innoDB DEFaULt ChARsEt=utf8mB4 cOLLATe=utF8mb4_0900_Ai_ci /*!80016 ENCrYPTION='y' */
sET gLobal tAble_encryption_privIlEGE_cHeck=falsE;
SET SEssIoN DEfault_taBlE_enCrypTIOn=falSe;
# clEAn Up
DROP DAtABASE DB1;
DrOp TABLESpAcE ts1;
#
`````````````````````````````````````````````````````````
# ReQuEst To cReate ENcryPted taBlespace With
ts1;
CREATE TABLE db1.t2 ( f1 int) TA BLESP ACE =ts 1; 
SHO W CR EATE TABLE db1 . t1;Table	Create Table
t1CREAT ET ABLE `t 1` (  `f1`i nt D EFA UL TNUL L)  / *!501 00TABLESP ACE `ts1`*/EN GINE=InnoDBD EF AULT CHARS ET= utf8mb4 COLL ATE =utf8m b4 _09 0 0_ai_ ciSHOWCREATE TABLEdb1.t2;
T ab l e	Crea t e Table t 2CREA TE TABLE `t2` (
`f 1 ` int DEFAULTNULL
)  / * !5 0 1 00TAB LESPACE `t s1 ` */E NGINE=I n no D B DEF A ULT CHARSET=u tf8mb4 COLL A TE= utf8mb 4_ 090 0 _ai_ci 
SETSE S SIO N default_t able _encrypti on=tru e ;
# Run ALTER T ABLESP ACE 
SE T GL O BA Ltab le _ enc r yp tio n _pr ivilege_ ch ec k=fal se;A L T E R TA BLE SPAC E ts1  ENCRYPTION=' y'; 
SHO W  WA RNING S;
Le velCo de	Me ssageSHOWCR EATE TABLE db1. t1;Table	Cre ate  T abl et1	CR E ATE TA BLE  `t 1` (
 `f1` in t  DE FA U L T  N ULL
) /*!50100 TAB LE S P AC E `ts1`*/ ENG I NE =I n noDB DEF AU LTCHAR S E T=utf 8mb4 CO LLATE=ut f8mb4_ 0 90 0_ ai_ci / *! 80016EN CRY PTI ON='Y '  */SHOW C REATE TA BLE d b 1.t2;
Table	Cr e ate Table
t2C RE A T ET ABLE  `t 2` (
  `f1`  int DEFA ULTN UL L
) /*!50 100 T AB L ES P ACE `ts1` */ ENGINE =I nnoDBDEFAU LT CHARSET=ut f8mb4 COLL A T E =utf8mb4 _090 0 _a i _ci /*!80016 E NCRYP TION='Y' * / 
SET GLO BAL t able_enc ryption_p r i vilege_c hec k=f als e;S E TSESSION defau l t _tab le _encryp tio n=false ;
#  cl ean  up 
D ROP DATAB ASE db1; 
D RO PTA BLE SPACE ts1;
#
` `` ``` `` ``` ````` ` `````` ````` ```` `` `` ` ``` ``````` ` `` ` ` ```` `#Requ est  t o cre atee ncr ypted t ablespace  wi t h
ts1;
CREATE TABLE_db1.t2 (f1_int) TABLESPACE=ts1;
SHOW CREATE TABLE_db1.t1;
Table	Create Table
t1	CREATE_TABLE_`t1` (
__`f1` int DEFAULT_NULL
) /*!50100 TABLESPACE_`ts1` */ ENGINE=InnoDB DEFAULT_CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SHOW CREATE_TABLE_db1.t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `f1` int DEFAULT NULL
) /*!50100 TABLESPACE `ts1` */_ENGINE=InnoDB_DEFAULT CHARSET=utf8mb4_COLLATE=utf8mb4_0900_ai_ci
SET_SESSION_default_table_encryption=true;
# Run ALTER TABLESPACE
SET GLOBAL_table_encryption_privilege_check=false;
ALTER TABLESPACE ts1 ENCRYPTION='y';
SHOW WARNINGS;
Level	Code	Message
SHOW_CREATE TABLE_db1.t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `f1` int_DEFAULT_NULL
) /*!50100 TABLESPACE_`ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016 ENCRYPTION='Y' */
SHOW_CREATE TABLE db1.t2;
Table	Create Table
t2	CREATE TABLE `t2`_(
  `f1`_int_DEFAULT_NULL
) /*!50100 TABLESPACE `ts1`_*/ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!80016_ENCRYPTION='Y' */
SET GLOBAL table_encryption_privilege_check=false;
SET SESSION default_table_encryption=false;
#_clean up
DROP DATABASE db1;
DROP TABLESPACE ts1;
#
`````````````````````````````````````````````````````````
# Request_to create encrypted tablespace with