Skip to content Skip to main navigation Skip to footer

Grant and Revoke Permissions to Database Using phpMyAdmin

July 9, 2018

Category: How To

You can customize the database permission if the server allows this.

For WordPress website, you can leave only the following permissions enabled:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • ALTER (for updates)
  • CREATE TABLE
  • DROP TABLE
  • INDEX

Follow the pictures:

  1. Login to phpMyAdmin and select to see all the databases.

2. 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: