Skip to content

sql-statement-flush-privileges.md

Latest commit

 

History

History
48 lines (33 loc) · 1.43 KB

sql-statement-flush-privileges.md

File metadata and controls

48 lines (33 loc) · 1.43 KB
Raw
title FLUSH PRIVILEGES | TiDB SQL Statement Reference
summary An overview of the usage of FLUSH PRIVILEGES for the TiDB database.
aliases
/docs/dev/sql-statements/sql-statement-flush-privileges/
/docs/dev/reference/sql/statements/flush-privileges/

FLUSH PRIVILEGES

The FLUSH PRIVILEGES statement refreshes the in-memory privilege cache of TiDB from the privilege tables. You must execute this statement after manually editing privilege tables such as mysql.user. However, executing this statement is not necessary after using privilege statements like GRANT or REVOKE. To execute this statement, the RELOAD privilege is required.

Synopsis

FlushStmt ::=
    'FLUSH' NoWriteToBinLogAliasOpt FlushOption

NoWriteToBinLogAliasOpt ::=
    ( 'NO_WRITE_TO_BINLOG' | 'LOCAL' )?

FlushOption ::=
    'PRIVILEGES'
|   'STATUS'
|    'TIDB' 'PLUGINS' PluginNameList
|    'HOSTS'
|   LogTypeOpt 'LOGS'
|   TableOrTables TableNameListOpt WithReadLockOpt

Examples

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

MySQL compatibility

The FLUSH PRIVILEGES statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.

See also