minimum mysql permissions for wordpress admin user (3 posts)

  1. idiotprogrammer
    Posted 12 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
    Posted 12 years ago #

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

  3. Mike Little
    Posted 12 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

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.