forgot to give sufficient privileges

  • In my new wordpress install, I gave the MySQL wordpress user select, insert, update, delete, and create privileges. The install choked when it tried to “alter” a table. What privileges are required for wordpress to operate correctly?
    -Rod

Viewing 6 replies - 1 through 6 (of 6 total)

  • all wont hurt a bit.

    Thread Starter Anonymous

    So if my hosting provider allows me only select, insert, delete, update, alter, index, create, and drop then I’m hosed? Just out of luck??? Screwed?????

    just for my information, what is left?

    A complete (so far as I can determine) list of user privileges that can be granted or denied to any db user in MySQL 4.0.15:
    ———————————————-
    Select_priv
    Insert_priv
    Update_priv
    Delete_priv
    Create_priv
    Drop_priv
    Reload_priv
    Shutdown_priv
    Process_priv
    File_priv
    Grant_priv
    References_priv
    Index_priv
    Alter_priv
    Show_db_priv
    Super_priv
    Create_tmp_table_priv
    Lock_tables_priv
    Execute_priv
    Repl_slave_priv
    Repl_client_priv
    ———————————————-
    I, too, would like to know exactly which of these are REQUIRED for WordPress to work, which (if any) are optional but recommended, and which of them are NOT REQUIRED. I cannot find this information anywhere in the documentation nor on any of these forums. I’d prefer to deny any privileges I don’t absolutely have to grant for the software to work, but trial and error doesn’t seem practical with this many of them.

    I’m running a new test installation with only these privileges enabled for the USER_NAME that opens the database:

    Select_priv
    Insert_priv
    Update_priv
    Delete_priv
    Create_priv
    Index_priv
    Alter_priv
    Drop_priv

    and it seems to work.

    Some of these might be unnecessary, but I don’t believe so.

    Claude

    I’ve spent some time looking at the sql interface and I can confirm that Claude is correct. You will need all of these:

    select, insert, update, delete, create, index, alter and drop.

    Hope that helps.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘forgot to give sufficient privileges’ is closed to new replies.