INSERT statements
UPDATE statements
DELETE statements
CREATE tables
DROP tables
— and probably an ALTER as well.
GRANT ALL is necessary. The need to have SELECT, INSERT, UPDATE, and DELETE privileges is obvious; that’s how WordPress displays, stores, and manages content and settings. ALTER privilege is critical for upgrades (sometimes, new versions of WordPress and/or plugins need to change table structure). CREATE TABLE privilege is required for initial install of both WordPress and plugins that maintain their own data tables. DROP TABLE privilege is needed for plugins to uninstall themselves completely.
Just came across this thread.
im installing wp on fasthosts and according to their documentation i cannot grant ALL permissions. Are the following that they do allow sufficient?
Using the SSH command-line, you can grant the following permissions to MySQL database users on our shared hosting platform:
ALTER
CREATE
CREATE TEMPORARY TABLES
DELETE
DROP
INDEX
INSERT
LOCK TABLES
SELECT
UPDATE
The permissions that you cannot grant are:
ALL
FILE
PROCESS
RELOAD
SHOW DATABASES
Thanks