6

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';

1 Answer 1

9

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

  • SELECT
  • 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.

1
  • 1
    SELECT seems pretty important.
    – Jake
    Apr 2, 2019 at 8:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .