RESET reset_option [, reset_option] ...
RESET statement causes an
implicit commit. See Section 15.3.3, “Statements That Cause an Implicit Commit”.
The following list describes the permitted
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 REPLICAin place of
RESET SLAVEfrom MySQL 8.0.22.