encrypted tablespace with default_table_encryption='y' # [ALTER TABLESPACE] Case 00 ) ````````````````````````````````````````````````````````` # Create required schema to run ALTER TABLESPACE. CREATE TABLESPACE ts0 ADD DATAFILE 'df_u.ibd' ENCRYPTION='y'; CREATE DATABASE db0 DEFAULT ENCRYPTION='y'; CREATE TABLE db0.t0 (f0 int) TABLESPACE=ts0 ENCRYPTION='y'; CREATE TABLE db0.t0 (f0 int) TABLESPACE=ts0 ENCRYPTION='y'; SHOW CREATE TABLE db0.t0; Table Create Table t0 CREATE TABLE `t0` (   `f0` int DEFAULT NULL ) /*!00000 TABLESPACE `ts0` */ ENGINE=InnoDB DEFAULT CHARSET=utf0mb0 COLLATE=utf0mb0_0000_ai_ci /*!00000 ENCRYPTION='y' */ SHOW CREATE TABLE db0.t0; Table Create Table t0 CREATE TABLE `t0` (   `f0` int DEFAULT NULL ) /*!00000 TABLESPACE `ts0` */ ENGINE=InnoDB DEFAULT CHARSET=utf0mb0 COLLATE=utf0mb0_0000_ai_ci /*!00000 ENCRYPTION='y' */ SET SESSION default_table_encryption=false; # Run ALTER TABLESPACE SET GLOBAL table_encryption_privilege_check=true; ALTER TABLESPACE ts0 ENCRYPTION='n'; 