--source include/no_valgrind_without_big.inc --source include/have_fips.inc # Data directory location --let CURRENT_DATADIR = `SELECT @@datadir` --let CURRENT_PERSISTED_FILE = `SELECT CONCAT('$CURRENT_DATADIR', '/mysqld-auto.cnf')` --error 0,1 --remove_file $CURRENT_PERSISTED_FILE # Pre-8.0.34 format persisted variables filie --let PRE8034_PERSISTED_VARIABLES_FILE = `SELECT CONCAT('$MYSQL_TEST_DIR', '/std_data/pre8034_mysqld-auto.cnf')` --echo # Copy Pre-8.0.34 format persisted variables file to data directory --copy_file $PRE8034_PERSISTED_VARIABLES_FILE $CURRENT_PERSISTED_FILE --echo # Restart the server --source include/restart_mysqld_no_echo.inc --echo # Verify that persisted variable file was read properly: Should show 1 entry SELECT * FROM performance_schema.persisted_variables ORDER BY variable_name ASC; --echo # Check the actual values SELECT @@global.ssl_fips_mode; --echo # Modify persisted variables SET PERSIST_ONLY ssl_fips_mode=ON; --echo # Restart the server --source include/restart_mysqld_no_echo.inc --echo # Verify that persisted variable file was read properly: Should show 1 entry SELECT * FROM performance_schema.persisted_variables ORDER BY variable_name ASC; --echo # Check the actual values SELECT @@global.ssl_fips_mode; RESET PERSIST; --echo # Remove old format persisted variables file --remove_file $CURRENT_PERSISTED_FILE --echo # Cleanup: Restart with default options. --source include/force_restart.inc