Skip to content Skip to main navigation Skip to footer

Grant and Revoke Permissions to Database Using phpMyAdmin

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

Normally, the default WordPress database permissions are:

  • 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: