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.
