Syntax:
RESET reset_option [, reset_option] ...

reset_option: {
    MASTER
  | REPLICA
  | SLAVE
}

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

For information about the RESET PERSIST statement that removes
persisted global system variables, see [HELP RESET PERSIST].

RESET acts as a stronger version of the FLUSH statement. See [HELP
FLUSH].

The RESET statement causes an implicit commit. See
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html.

The following list describes the permitted RESET statement reset_option
values:

o RESET 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.

o RESET REPLICA

  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 REPLICA in place of
  RESET SLAVE from MySQL 8.0.22.

URL: https://dev.mysql.com/doc/refman/8.0/en/reset.html

