Support » Installing WordPress » minimum mysql permissions for wordpress admin user

  • 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • grant alter,delete,file,index,insert,reload,select,update on myweblog.* to mywebloguser@’%’ identified by ‘weblogadminpassword’;
    that right?

    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

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘minimum mysql permissions for wordpress admin user’ is closed to new replies.