Other Administrative Statements The  RESET  statement causes an implicit commit. See Section 13.3.3, “Statements That Cause an Implicit Commit” . The following list describes the permitted  RESET  statement  reset_option  values: Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Makes the replica forget its replication position in the source binary logs. Also resets the relay log by deleting any existing relay log files and beginning a new one. Use  RESET REPLICA  in place of  RESET SLAVE  from MySQL 8.0.22. 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 Section 5.1.9.3, “Persisted System Variables” . RESET PERSIST [[IF EXISTS]  system_var_name ] The privileges required for  RESET PERSIST  depend on the type of system variable to be removed: Depending on whether the variable name and  IF EXISTS  clauses are present, the  RESET PERSIST statement has these forms: See Section 5.1.9.1, “System Variable Privileges” . RESET PERSIST; You must have privileges for removing both dynamic and read-only system variables if  mysqld- auto.cnf  contains both kinds of variables. 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. RESET PERSIST  system_var_name ; RESET PERSIST IF EXISTS  system_var_name ; RESET PERSIST  is not affected by the value of the  persisted_globals_load  system variable. 2980 • RESET MASTER • RESET REPLICA | SLAVE 13.7.8.7 RESET PERSIST Statement •For dynamic system variables, this statement requires the  SYSTEM_VARIABLES_ADMIN  privilege (or the deprecated  SUPER  privilege). •For read-only system variables, this statement requires the  SYSTEM_VARIABLES_ADMIN  and PERSIST_RO_VARIABLES_ADMIN  privileges. •To remove all persisted variables from  mysqld-auto.cnf , use  RESET PERSIST  without naming any system variable: •To remove a specific persisted variable from  mysqld-auto.cnf , name it in the statement: •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: