A complete (so far as I can determine) list of user privileges that can be granted or denied to any db user in MySQL 4.0.15:
———————————————-
Select_priv
Insert_priv
Update_priv
Delete_priv
Create_priv
Drop_priv
Reload_priv
Shutdown_priv
Process_priv
File_priv
Grant_priv
References_priv
Index_priv
Alter_priv
Show_db_priv
Super_priv
Create_tmp_table_priv
Lock_tables_priv
Execute_priv
Repl_slave_priv
Repl_client_priv
———————————————-
I, too, would like to know exactly which of these are REQUIRED for WordPress to work, which (if any) are optional but recommended, and which of them are NOT REQUIRED. I cannot find this information anywhere in the documentation nor on any of these forums. I’d prefer to deny any privileges I don’t absolutely have to grant for the software to work, but trial and error doesn’t seem practical with this many of them.
