Monday 16 October 2006 11:49:08 pm

Hello Matt

I always assign these table-specific privileges to the MySQL user used by eZ publish (I'm using the MySQL Administrator application):

CREATE
DROP
ALTER
DELETE
INDEX
INSERT
SELECT
UPDATE
CREATE TEMPORARY TABLES
LOCK TABLES

I think you can remove the following privileges after running the eZ publish setup wizard or after a manual setup:

CREATE
DROP
ALTER
INDEX

You will have to re-enable them before running any eZ publish upgrade scripts (mysql or PHP CLI), unless you run them with a more privileged MySQL user like root.

More information about the privileges on http://dev.mysql.com/doc/en/GRANT.html

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org