Syntax:
RESET PERSIST [[IF EXISTS] system_var_name]

RESET PERSIST removes persisted global system variable settings from
the mysqld-auto.cnf option file in the data directory. Removing a
persisted system variable causes the variable no longer to be
initialized from mysqld-auto.cnf at server startup. For more
information about persisting system variables and the mysqld-auto.cnf
file, see
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
.

Prior to MySQL 8.0.32, this statement did not work with variables whose
name contained a dot character (.), such as MyISAM multiple key cache
variables and variables registered by components. (Bug #33417357)

The privileges required for RESET PERSIST depend on the type of system
variable to be removed:

o For dynamic system variables, this statement requires the
  SYSTEM_VARIABLES_ADMIN privilege (or the deprecated SUPER privilege).

o For read-only system variables, this statement requires the
  SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges.

See
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
.

Depending on whether the variable name and IF EXISTS clauses are
present, the RESET PERSIST statement has these forms:

o To remove all persisted variables from mysqld-auto.cnf, use RESET
  PERSIST without naming any system variable:

RESET PERSIST;

  You must have privileges for removing both dynamic and read-only
  system variables if mysqld-auto.cnf contains both kinds of variables.

o To remove a specific persisted variable from mysqld-auto.cnf, name it
  in the statement:

RESET PERSIST system_var_name;

  This includes plugin system variables, even if the plugin is not
  currently installed. If the variable is not present in the file, an
  error occurs.

o To remove a specific persisted variable from mysqld-auto.cnf, but
  produce a warning rather than an error if the variable is not present
  in the file, add an IF EXISTS clause to the previous syntax:

RESET PERSIST IF EXISTS system_var_name;

URL: https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html

