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 these steps:
- Login to phpMyAdmin and click on the Home icon to see all the databases.
- Click the Check Privileges link next to your WordPress database.
- Click the Edit Privileges link next to the database user.
- Change the privileges you want to have for your website and click the Go button to save the changes.
