WordPress.org

Ready to get started?Download WordPress

Forums

minimum mysql permissions for wordpress admin user (3 posts)

  1. idiotprogrammer
    Member
    Posted 11 years ago #

    I'm creating a testblog for other users to play with. I don't want them to mess them with it too much. Although I'm allowing image uploads (maybe I'll rue it), I'll set a low limit on file size. But I was wondering: what are the minimum mysql permissions to set for the wordpress admin account?
    grant myweblog.* to myself@''%' identified by 'mypassword'
    seems awfully generous.

  2. idiotprogrammer
    Member
    Posted 11 years ago #

    grant alter,delete,file,index,insert,reload,select,update on myweblog.* to mywebloguser@'%' identified by 'weblogadminpassword';
    that right?

  3. Mike Little
    Member
    Posted 11 years ago #

    A couple of points.
    You probably want to restrict that to user@localhost rather than '%'
    Once the blog has been created then you only need select, insert, update, delete
    During installation (and possibly during updates) you need create, alter, and drop too. But you could revoke those once the installation/update has run successfully
    Mike

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.