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:

RESET PERSIST;

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

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.

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;