Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

Example

GRANT SELECT ON database.* TO user@'localhost';
share|improve this question

1 Answer 1

up vote 7 down vote accepted

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

  • INSERT
  • UPDATE
  • DELETE
  • CREATE
  • DROP
  • ALTER
  • INDEX

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

 
discard

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.