navicat一键收回权限语句_使用MySQL REVOKE语句收回mysql账户的权限

Summary:in this tutorial, you will learn how to use MySQL REVOKEstatement to revoke privileges from MySQL accounts.

We are highly recommend that you follow the tutorials below to have a better understanding of how MySQL REVOKE works:

Getting Started with MySQL Access Control System

MySQL Create User

How to Use MySQL GRANT to Grant Privileges to Account

MySQL REVOKE Syntax

In order to revoke privileges from an account, you use the MySQL REVOKE statement. The syntax of MySQL REVOKE statement is as follows:

REVOKE privilege_type[(column_list)][,priv_type[(column_list)]]...ON[object_type]privilege_level

FROM user[,user]...

Let’s examine the MySQL REVOKE statement in more detail.

You specify a list of privileges that you want to revoke from an account right after the REVOKE keyword. You need to separate privileges by comma.

ON clause specifies the privilege l