Name

RESET

Synopsis

RESET {MASTER|SLAVE|QUERY CACHE}[, ...]

Use this statement to reset certain server settings and files. It’s similar to the FLUSH statement, but more powerful for its specific uses. The RELOAD privilege is required to use it. Multiple options may be given in a comma-separated list. Currently, you can reset the MASTER, QUERY CACHE, and SLAVE options. See the RESET MASTER and the RESET SLAVE statements in Chapter 8 for detailed explanations of each option. The QUERY CACHE option clears the cache containing SQL query results.

Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.