After I install wordpress during my production atmosphere, the wordpress database is going to be imported from the dump and plug ins is going to be installed by hand, by root, therefore the database user does not need to create tables. Also, some tables ought to be read-only out of this database user (for example the consumer table).

It is always good if a person clarified this with privs for installation as well as for running individually.

My prediction: choose, place (in certain tables), remove (in certain tables), update (in certain tables)

Some questions:

  • "create" is just needed throughout installation and when you put in plug ins requiring separate tables, correct?

  • Alter might be needed if your wordpress plugin have to update it's tables, correct?

  • Are drop ever needed, maybe whenever you remove a wordpress plugin?

you pointed out all needed priviledges aside from index.