Forums / Install & configuration / MySQL Database Privileges

MySQL Database Privileges

Author Message

Matt Brady

Monday 16 October 2006 9:57:18 pm

What privileges are actually required to be GRANTed to run 3.8.3 on MySQL 4.1.2?
On one of my servers everything works fine but on another I need to GRANT more. For example CREATE TEMPORARY TABLES isn't on as default.
BTW the hosting company on the second server won't allow GRANT ALL so I need that actual privilege requirements.
Would be a useful addition to the Installation Requirements docs also :)

It's not easy being easy.

Kristof Coomans

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