 This tablespace can't be decrypted, because one of table's schema has default encryption ON and user doesn't have enough privilege. SHOW WARNINGS; Level Code Message Error 0000 This tablespace can't be decrypted, because one of table's schema has default encryption ON and user doesn't have enough privilege. 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 GLOBAL table_encryption_privilege_check=false; SET SESSION default_table_encryption=false; # clean up DROP DATABASE db0; DROP TABLESPACE ts0; # # [ALTER TABLESPACE] Case 00 ) ````````````````````````````````````````````````````````` # Grant user with TABLE_ENCRYPTION_ADMIN GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u0@localhost; # 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'; Warnings: Warning 0000 Creating an unencrypted table in a database with default encryption enabled. SHOW WARNINGS; Level Code Message Warning 0000 Creating an unencrypted table in a database with default encryption enabled. 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='N' */ 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='N' */ SET GLOBAL table_encryption_privilege_check=false; SET SESSION default_table_encryption=false; # clean up # Revoke TABLE_ENCRYPTION_ADMIN from user REVOKE TABLE_ENCRYPTION_ADMIN ON *.* FROM u0@localhost; DROP DATABASE db0; DROP TABLESPACE ts0; # # C