WordPress.org

1. MarkE
   Member
   Posted 8 years ago #

   Which global privileges in MySQL do I grant to a WP user? I do not want to grant all of them, which would give the user total control over my MySQL installation, so what are the minimum I MUST have turned on in order for WP to function correctly?
   I am using Navicat for my MySQL administration.
   Thanks,
   Mark E

2. Ryan Boren
   WordPress Dev
   Posted 8 years ago #

   Grant all priviledges but limit them to the WordPress DB.
   So, instead of:
   GRANT ALL PRIVILEGES ON *.* ...
   do:
   GRANT ALL PRIVILEGES ON wordpress.* ...
   where wordpress is the name of your WordPress DB. If you don't want them to be able to drop the DB, do something like:
   GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON wordpress.* ...
   See: Adding Users

3. MarkE
   Member
   Posted 8 years ago #

   Thank you very much. Then I will leave the global settings for the USER unchecked, and use the database settings you suggested above.
   Mark E

4. BAKSHI
   Member
   Posted 8 years ago #

   Are you sure CREATE should be granted?

Topic Closed

This topic has been closed to new replies.