Reload grant tables

sql

FLUSH PRIVILEGES;

Explanation

Usually unnecessary when using `CREATE USER`, `GRANT`, or `REVOKE`, but sometimes seen in legacy workflows.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing grants and roles

Allow an app account to use one schema.

Open In sheetsqlsame section

Give broad schema-level rights.

Open In sheetsqlsame section

Inspect the effective privileges granted to an account.

Open In sheetsqlsame section

Remove previously granted rights.

Open In sheetsqlsame section

Create an account identified by user name and host.

Rotate credentials for an existing account.