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 runtime parameters.

Examples

The following example resets the query_group parameter to its default value:

reset query_group;

The following example resets all runtime parameters to their default values.

reset all;