minimum mysql permissions for wordpress admin user

  • idiotprogrammer

    (@idiotprogrammer)


    20 years, 10 months 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter idiotprogrammer

    (@idiotprogrammer)

    20 years, 10 months ago

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

    Mike Little

    (@mikelittle)

    20 years, 10 months 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

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