Grant and Revoke Permissions to Database Using phpMyAdmin
July 9, 2018
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:
- 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:
