Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is phpMyAdmin capable of granting rights 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;

share|improve this question

2 Answers 2

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:

share|improve this answer
    
Yes, this gives rights to a single user, but not to several users as mentioned in my question. I don't want to do this over and over again for every single user I want to give rights to. It would be ok if MySQL understood the concept of roles, then I could give a role to a bunch of users and then grant the rights to that role. Unfortunately, MySQL lacks this important feature. So I will to it rather using the command line. –  Holger Jakobs Jan 7 at 10:30

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.

share|improve this answer
    
That's exactly what I already mentioned in my question, so I have been aware of that. Thanks anyway. –  Holger Jakobs Jan 7 at 10:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.