RESET
Restores the value of a configuration parameter to its default value.
You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the SET command. To display the current value of a parameter, use the SHOW command.
Syntax
RESET { parameter_name | ALL }
Parameters
- parameter_name
-
Name of the parameter to reset. See Modifying the Server Configuration for more documentation about parameters.
- ALL
-
Resets all run-time parameters.
Examples
The following example resets the query_group
parameter to its default
value:
reset query_group;
The following example resets all run-time parameters to their default values:
reset all;