MySQL - RESET Statement

The RESET statement for MySQL is used to reset various types of servers. Using this statement, you can reset a MySQL master, slave or, replica.

The RESET MASTER statement removes all the binary logs (in the index file), resets the binary log index file to be empty, and creates a new binary log file.

RESET MASTER;

The RESET SLAVE statement forgets the current replication position, removes all the existing relay logs creates a new one.

RESET SLAVE;

The RESET REPLICA statement forgets the current replication position, removes all the existing relay logs creates a new one.

RESET REPLICA;