WordPress.org

Support

Support » Installation » What are the minimum global privileges a WP user n

What are the minimum global privileges a WP user n

  • 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

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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

    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

    Are you sure CREATE should be granted?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘What are the minimum global privileges a WP user n’ is closed to new replies.