13.7.6.6. `RESET` Syntax

RESET reset_option [, reset_option] ...

The RESET statement is used to clear the state of various server operations. You must have the RELOAD privilege to execute RESET.

RESET acts as a stronger version of the FLUSH statement. See Section 13.7.6.3, "FLUSH Syntax".

The RESET statement causes an implicit commit. See Section 13.3.3, "Statements That Cause an Implicit Commit".

In MySQL 5.7.1, gtid_next must be set to AUTOMATIC before issuing this statement. This restriction does not apply in MySQL 5.7.2 or later. (Bug #16062608, Bug #16715809, Bug #69045)

reset_option can be any of the following:

MASTER

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.
QUERY CACHE

Removes all query results from the query cache.
SLAVE

Makes the slave forget its replication position in the master binary logs. Also resets the relay log by deleting any existing relay log files and beginning a new one.

13.7.6.6. RESET Syntax

13.7.6.6. `RESET` Syntax