Debian Codegraph @

mysql-test/suite/component_keyring_file/r/upgrade.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating custom global manifest file for MySQL server
4 # Creating custom global configuration file for keyring component: component_keyring_file
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # This test upgrades schema from 5.7, 8.0 to 8.0.15 where we
8 # introduce serveral ENCRYPTION control capabilities in MySQL
9 # (WL#12261). Specifically this test upgrades from,
10 #
11 # a) 5.7.25 where, we support file-per-tablespace
12 # encryption and not general tablespace encryption. We upgrade from
13 # FRM to DD.
14 # b) 8.0.12 where, we support file-per-tablespace
15 # encryption and not general tablespace encryption. We upgrade from
16 # DD to DD.
17 # c) 8.0.13 where, we support file-per-tablespace
18 # encryption and general tablespace encryption. We upgrade from
19 # DD to DD.
20 #
21 # The schema used is during upgrade is as described in
22 # upgrade_schema.test placed in respective *.zip file. The expectation
23 # is that the encryption clause for tables and tablespaces are
24 # stored as designed by wl12261 after the upgrade is completed.. The
25 # results are verified by querying the mysql.tables.options and
26 # mysql.tablespaces.options.
27 ########################################################################
28 # Stop the running server.
29 ########################################################################
30 # Taking backup of local keyring file for keyring component: component_keyring_file
31 ########################################################################
32 # Unzip a 5.7.25 datadir with bug data, start the server against it
33 ########################################################################
34 ########################################################################
35 # Copy and unzip the datadir.
36 ########################################################################
37 ########################################################################
38 # Migrate keys from plugin to component.
39 ########################################################################
40 # Taking backup of global manifest file for MySQL server
41 # Taking backup of global configuration file for keyring component: component_keyring_file
42 # Applying migration config for keyring component: component_keyring_file
43 # Performing keyring migration
44 # Restoring global configuration file from backup for keyring component: component_keyring_file
45 # Restore global manifest file for MySQL server from backup
46 ########################################################################
47 # Restart the server against the unzipped datadir.
48 ########################################################################
49 SET DEBUG='+d,skip_dd_table_access_check';
50 SELECT schema_id, t.name, t.options, t.tablespace_id
51 FROM mysql.tables t JOIN mysql.schemata sch
52 ON t.schema_id = sch.id WHERE sch.name LIKE 'db1' ORDER BY t.name;
53 schema_id name options tablespace_id
54 4 c1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
55 4 c2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
56 4 c3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
57 4 h1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
58 4 h2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
59 4 h3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
60 4 i1 avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
61 4 i2 avg_row_length=0;encrypt_type=y;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
62 4 i3 avg_row_length=0;encrypt_type=n;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
63 4 i4 avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
64 4 i_part1 avg_row_length=0;encrypt_type=N;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
65 4 i_part2 avg_row_length=0;encrypt_type=y;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
66 4 i_part3 avg_row_length=0;encrypt_type=n;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
67 4 i_part4 avg_row_length=0;encrypt_type=N;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
68 4 i_ts1 avg_row_length=0;encrypt_type=N;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; 27
69 4 i_ts2 avg_row_length=0;encrypt_type=n;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; 27
70 4 i_ts3 avg_row_length=0;encrypt_type=N;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; 27
71 SELECT id, name, options FROM mysql.tablespaces
72 WHERE name LIKE 'ts%' OR name LIKE '%db1%';
73 id name options
74 26 ts0 encryption=N;
75 27 ts1 encryption=N;
76 28 db1/i1 encryption=N;
77 29 db1/i2 encryption=Y;
78 30 db1/i3 encryption=N;
79 31 db1/i4 encryption=N;
80 32 db1/i_part1#p#p0 encryption=N;
81 33 db1/i_part1#p#p1 encryption=N;
82 34 db1/i_part1#p#p2 encryption=N;
83 35 db1/i_part2#p#p0 encryption=Y;
84 36 db1/i_part2#p#p1 encryption=Y;
85 37 db1/i_part2#p#p2 encryption=Y;
86 38 db1/i_part3#p#p0 encryption=N;
87 39 db1/i_part3#p#p1 encryption=N;
88 40 db1/i_part3#p#p2 encryption=N;
89 41 db1/i_part4#p#p0 encryption=N;
90 42 db1/i_part4#p#p1 encryption=N;
91 43 db1/i_part4#p#p2 encryption=N;
92 SET DEBUG='-d,skip_dd_table_access_check';
93 Check if upgrade root gets TABLE_ENCRYPTION_ADMIN privilege.
94 SHOW GRANTS FOR 'root'@'localhost';
95 Grants for root@localhost
96 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
97 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
98 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
99 ########################################################################
100 # Remove copied files and stop the server.
101 ########################################################################
102 # Removing local keyring file for keyring component: component_keyring_file
103 ########################################################################
104 # Unzip a 8.0.12 datadir with bug data, start the server against it
105 ########################################################################
106 ########################################################################
107 # Copy and unzip the datadir.
108 ########################################################################
109 ########################################################################
110 # Migrate keys from plugin to component.
111 ########################################################################
112 # Taking backup of global manifest file for MySQL server
113 # Taking backup of global configuration file for keyring component: component_keyring_file
114 # Applying migration config for keyring component: component_keyring_file
115 # Performing keyring migration
116 # Restoring global configuration file from backup for keyring component: component_keyring_file
117 # Restore global manifest file for MySQL server from backup
118 ########################################################################
119 # Restart the server against the unzipped datadir.
120 ########################################################################
121 SET DEBUG='+d,skip_dd_table_access_check';
122 SELECT schema_id, t.name, t.options, t.tablespace_id
123 FROM mysql.tables t JOIN mysql.schemata sch
124 ON t.schema_id = sch.id WHERE sch.name LIKE 'db1' ORDER BY t.name;
125 schema_id name options tablespace_id
126 7 c1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
127 7 c2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
128 7 c3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
129 7 h1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
130 7 h2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
131 7 h3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
132 7 i1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; NULL
133 7 i2 avg_row_length=0;encrypt_type=y;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
134 7 i3 avg_row_length=0;encrypt_type=n;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
135 7 i4 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; NULL
136 7 i_part1 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table;encrypt_type=N; NULL
137 7 i_part2 avg_row_length=0;encrypt_type=y;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
138 7 i_part3 avg_row_length=0;encrypt_type=n;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
139 7 i_part4 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table;encrypt_type=N; NULL
140 7 i_ts1 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; 8
141 7 i_ts2 avg_row_length=0;encrypt_type=n;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; 8
142 7 i_ts3 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; 8
143 SELECT id, name, options FROM mysql.tablespaces
144 WHERE name LIKE 'ts%' OR name LIKE '%db1%';
145 id name options
146 7 ts0 encryption=N;
147 8 ts1 encryption=N;
148 9 db1/i1 encryption=N;
149 10 db1/i2 encryption=Y;
150 11 db1/i3 encryption=N;
151 12 db1/i4 encryption=N;
152 13 db1/i_part1#p#p0 encryption=N;
153 14 db1/i_part1#p#p1 encryption=N;
154 15 db1/i_part1#p#p2 encryption=N;
155 16 db1/i_part2#p#p0 encryption=Y;
156 17 db1/i_part2#p#p1 encryption=Y;
157 18 db1/i_part2#p#p2 encryption=Y;
158 19 db1/i_part3#p#p0 encryption=N;
159 20 db1/i_part3#p#p1 encryption=N;
160 21 db1/i_part3#p#p2 encryption=N;
161 22 db1/i_part4#p#p0 encryption=N;
162 23 db1/i_part4#p#p1 encryption=N;
163 24 db1/i_part4#p#p2 encryption=N;
164 SET DEBUG='-d,skip_dd_table_access_check';
165 Check if upgrade root gets TABLE_ENCRYPTION_ADMIN privilege.
166 SHOW GRANTS FOR 'root'@'localhost';
167 Grants for root@localhost
168 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
169 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
170 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
171 ########################################################################
172 # Remove copied files and stop the server.
173 ########################################################################
174 # Removing local keyring file for keyring component: component_keyring_file
175 ########################################################################
176 # Unzip a 8.0.13 datadir with bug data, start the server against it
177 ########################################################################
178 ########################################################################
179 # Copy and unzip the datadir.
180 ########################################################################
181 ########################################################################
182 # Migrate keys from plugin to component.
183 ########################################################################
184 # Taking backup of global manifest file for MySQL server
185 # Taking backup of global configuration file for keyring component: component_keyring_file
186 # Applying migration config for keyring component: component_keyring_file
187 # Performing keyring migration
188 # Restoring global configuration file from backup for keyring component: component_keyring_file
189 # Restore global manifest file for MySQL server from backup
190 ########################################################################
191 # Restart the server against the unzipped datadir.
192 ########################################################################
193 SET DEBUG='+d,skip_dd_table_access_check';
194 SELECT schema_id, t.name, t.options, t.tablespace_id
195 FROM mysql.tables t JOIN mysql.schemata sch
196 ON t.schema_id = sch.id WHERE sch.name LIKE 'db1' ORDER BY t.name;
197 schema_id name options tablespace_id
198 7 c1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
199 7 c2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
200 7 c3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
201 7 h1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
202 7 h2 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
203 7 h3 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
204 7 i1 avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; NULL
205 7 i2 avg_row_length=0;encrypt_type=y;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
206 7 i3 avg_row_length=0;encrypt_type=n;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; NULL
207 7 i_part1 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table;encrypt_type=N; NULL
208 7 i_part2 avg_row_length=0;encrypt_type=y;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
209 7 i_part3 avg_row_length=0;encrypt_type=n;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;tablespace=innodb_file_per_table; NULL
210 7 i_ts1 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; 8
211 7 i_ts2 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; 9
212 7 i_ts3 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=Y; 10
213 7 i_ts4 avg_row_length=0;explicit_tablespace=1;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;encrypt_type=N; 11
214 SELECT id, name, options FROM mysql.tablespaces
215 WHERE name LIKE 'ts%' OR name LIKE '%db1%';
216 id name options
217 7 ts0 encryption=N;
218 8 ts1 encryption=N;
219 9 ts2 encryption=n;
220 10 ts3 encryption=y;
221 11 ts4 encryption=N;
222 12 ts5 encryption=N;
223 13 db1/i1 encryption=N;
224 14 db1/i2 encryption=Y;
225 15 db1/i3 encryption=N;
226 16 db1/i_part1#p#p0 encryption=N;
227 17 db1/i_part1#p#p1 encryption=N;
228 18 db1/i_part1#p#p2 encryption=N;
229 19 db1/i_part2#p#p0 encryption=Y;
230 20 db1/i_part2#p#p1 encryption=Y;
231 21 db1/i_part2#p#p2 encryption=Y;
232 22 db1/i_part3#p#p0 encryption=N;
233 23 db1/i_part3#p#p1 encryption=N;
234 24 db1/i_part3#p#p2 encryption=N;
235 SET DEBUG='-d,skip_dd_table_access_check';
236 Check if upgrade root gets TABLE_ENCRYPTION_ADMIN privilege.
237 SHOW GRANTS FOR 'root'@'localhost';
238 Grants for root@localhost
239 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
240 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
241 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
242 ########################################################################
243 # Remove copied files and stop the server.
244 ########################################################################
245 # Removing local keyring file for keyring component: component_keyring_file
246 ########################################################################
247 # Cleanup: Restart with default options.
248 ########################################################################
249 # Restoring local keyring file from backup for keyring component: component_keyring_file
250 ########################################################################
251 # Bug #29447073: UPGRADE FROM 8.0.16 TO TRUNK FAILS WHEN MYSQL TABLESPACE IS ENCRYPTED
252 ########################################################################
253 alter tablespace mysql encryption='Y';
254 alter tablespace mysql encryption='N';
255 ########################################################################
256 # Cleanup: Restart with default options.
257 ########################################################################
258 # ----------------------------------------------------------------------
259 # Teardown
260 # Removing local keyring file for keyring component: component_keyring_file
261 # Removing global configuration file for keyring component: component_keyring_file
262 # Removing global manifest file for MySQL server
263 # Restarting server without the manifest file
264 # ----------------------------------------------------------------------