WordPress blog not only uses its own tables when setting the CMS up, but also allows plugins to create the tables they need in the fly. So, when you create a WordPress website or blog, the MySQL user should have all privileges but GRANT. Here goes the list of privileges that a WordPress blog or website should have —
- ALTER
- CREATE
- CREATE TEMPORARY TABLES
- DELETE
- DROP
- INDEX
- INSERT
- LOCK TABLES
- SELECT
- UPDATE