What database privileges does a Wordpress blog really need?
What database privileges does a Wordpress Blog really need? I am setting up a few Wordpress blog sites. I have created a user in mysql that wordpress will use to access its database. The docs say to give this user all privileges on the database. Does it really need full privileges? I expect not, so does anyone know the min set of privileges that it really needs? 3 Answers I'm no Wordpress expert, but I would recommend it does actually have all privileges apart from GRANT. It will need to be able to create tables and insert/update etc. Several plugins use their own tables, which they create on the fly if they do not exist. I grant: ALTER CREATE CREATE TEMPORARY TABLES DELETE DROP INDEX INSERT LOCK TABLES SELECT UPDATE Hope that helps anyone else that looks into this. grant select, insert, delete, update, create, drop, alter on myblog Best practices for running Wordpress on the same domain as Rails app What's the best way to run Wordpress on the same do...