[How To] Grant and Revoke Permissions to Database Using phpMyAdmin

July 9, 2018 by John Darrel

How To 5 Comments

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:

John Darrel

Author

I am a WordPress Developer and I love creating plugins and themes for WordPress. It is a great CMS for any kind of business but we need to keep it a safe place.

I have over 15 years of experience in building plugins and themes for WordPress and other platforms.

Contact me if you have plugins that you want me to check before you insert them into your website. I will be happy to check them for security and speed.

Articles by John Darrel

5 Comments

Beth says:

November 14, 2019 at 1:46 am

I am unable to access my plug-in page and I think it’s a setting I used – this is why the report is saying I need to update my plug-ins

Reply to comment
P at Malone says:

October 2, 2020 at 2:56 pm

I can follow this apart from the last instruction. Which tables? Which privileges?

Reply to comment
- Senita Whitelaw says:
  
  May 12, 2021 at 9:47 am
  
  Hello! I too have the same question – which tables, which privileges? (May 2021)
  
  Reply to comment
Tony Hisir says:

December 16, 2020 at 9:50 pm

Hi John,
Thank you for creating a great plugin and replying to my inquiries so quickly.

Reply to comment
Urun dana says:

June 6, 2021 at 1:24 am

Hi.. I have trying to implement it to my website and caused error 500. What is the problem?

Reply to comment

[How To] Grant and Revoke Permissions to Database Using phpMyAdmin

John Darrel

Author

Previous

Next

5 Comments

Leave a comment Cancel reply