MySQL Database Privileges
MySQL Database Privileges
Tuesday 17 October 2006 6:57:18 am - 1 reply
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 
Tuesday 17 October 2006 8:49:08 am
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
You must be logged in to post messages in this topic!