QuestionsCategory: Technical QuestionWhich database privileges does a WordPress Blog really need?
Rick
asked 1 year 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
tech Staff
answered 1 year 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!



Your Answer