Grant and Revoke Permissions to Database Using phpMyAdmin

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: