How to grant and revoke rights to tables using phpMyAdmin

Question

Is phpMyAdmin capable of granting rights (permissions) on certain tables to users or roles?

When I look at the page of a database table there is no "rights" tab.

I have only found a place where I can give rights to single users.

What I need is granting some rights to several users at the same time like

grant insert, update, delete on customers to john, max, annie;

Answer 1

You can do that. Follow the pictures: In the "Privileges" tab which list your users click the "Edit Privileges" of the user.

Then select the database:

After that specific the privileges by checking them and then select your table as shown in the picture:

After you select your table, you can define the operations in detailed:

Answer 2

phpMyAdmin can't do such a granular rights setup, but you can do this with pure SQL. See this reference for details. It's basically just writing "GRANT" statements yourself which you can pass to phpMyAdmin.

The GRANT syntax allows you to specify multiple users in a single query.:

GRANT SELECT,INSERT,UPDATE,DELETE ON customers.* TO 'john', 'annie', 'max';

Answer 3

With PHP my admin, anything you do shows you the query that it ran to do it at the top of the page. Copy these querys. Switch out the username and and host and rerun them.

Not GUI but if doing several users then you just do it through the GUI once and a quick copy paste for each user.

follow @shgnInc answer for the GUI part.