WordPress.org

Ready to get started?Download WordPress

Forums

What are the minimum global privileges a WP user n (4 posts)

  1. MarkE
    Member
    Posted 10 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 10 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 10 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 10 years ago #

    Are you sure CREATE should be granted?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.