Which database privileges does a WordPress Blog really need?

Questions › Which database privileges does a WordPress Blog really need?
Vote Up 0 Vote Down
Rick
asked 3 years ago
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?
1 Answers
Vote Up 0 Vote Down
tech Staff
answered 3 years ago
Hi,
I think it's some database privileges following:
  • ALTER
  • CREATE
  • CREATE TEMPORARY TABLES
  • DELETE
  • DROP
  • INDEX
  • INSERT
  • LOCK TABLES
  • SELECT
  • UPDATE
Hope that helps!

Please login or Register to submit your answer