I try to execute in pma

REVOKE FILE, SHUTDOWN, SUPER ON *.* FROM 'user'@'localhost';

pma gives an error

Unrecognized statement type. (near "REVOKE" at position 0)

Separately for FILE , SHUTDOWN and SUPER obtained. The documentation syntax is correct.

 REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] priv_level FROM user [, user] ...

How to make a request correctly?

  • You refer to the original MySQL documentation, not MariaDB. In the original MySQL, your request runs without errors, although yes, phpMyAdmin highlights it as erroneous. In addition, in phpMyAdmin you can manage access rights using the graphical interface. - cheops
  • > in phpMyAdmin you can manage access rights using the graphical interface. Is it possible in more detail how? In my tab "User Accounts" in the tab "Overview of User Accounts", you can only see, export and delete, but not withdraw or assign. - Ilya Indigo

1 answer 1

Understood. In fact, the request is correct and works, only it causes an error when trying to revoke an already withdrawn or unassigned privilege.

At the same time, that was a shock for me, GRANT exactly the opposite, allows you to assign an already assigned privilege, but gives an error when you try to assign an unassigned or withdrawn privilege to yourself, while the GRANT privilege is assigned to it.

In this case, of course, if the UPDATE privilege is not revoked, you can set the required privilege in the user table of the mysql database in the 'Y' column, but why such hemorrhoids?