Debian Codegraph @

mysql-test/suite/auth_sec/r/fips_persisted_option.result

raw
1 # Copy Pre-8.0.34 format persisted variables file to data directory
2 # Restart the server
3 # Verify that persisted variable file was read properly: Should show 1 entry
4 SELECT * FROM performance_schema.persisted_variables ORDER BY variable_name ASC;
5 VARIABLE_NAME VARIABLE_VALUE
6 ssl_fips_mode ON
7 # Check the actual values
8 SELECT @@global.ssl_fips_mode;
9 @@global.ssl_fips_mode
10 ON
11 Warnings:
12 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
13 # Modify persisted variables
14 SET PERSIST_ONLY ssl_fips_mode=ON;
15 Warnings:
16 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
17 # Restart the server
18 # Verify that persisted variable file was read properly: Should show 1 entry
19 SELECT * FROM performance_schema.persisted_variables ORDER BY variable_name ASC;
20 VARIABLE_NAME VARIABLE_VALUE
21 ssl_fips_mode ON
22 # Check the actual values
23 SELECT @@global.ssl_fips_mode;
24 @@global.ssl_fips_mode
25 ON
26 Warnings:
27 Warning 1287 '@@ssl_fips_mode' is deprecated and will be removed in a future release.
28 RESET PERSIST;
29 # Remove old format persisted variables file
30 # Cleanup: Restart with default options.