Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to create a new MySQL user to manage my wordpress site. What privellages are needed for wordpress?

I assume INSERT is also needed and maybe DROP?


GRANT SELECT ON database.* TO user@'localhost';
share|improve this question
up vote 8 down vote accepted

The official documentation says to give the user all privs. Others suggest that you can restrict it to

  • DROP

Plugins etc can though call any statement they want so you would have to thoroughly test everything you install if you restrict privileges.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.