MySQL Database Privileges

Next topic

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

Author

Message

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

eZ debug

Timing:	Jan 30 2025 22:28:02
Script start
Timing:	Jan 30 2025 22:28:02
Module start 'layout'
Timing:	Jan 30 2025 22:28:02
Module start 'content'
Timing:	Jan 30 2025 22:28:02
Module end 'content'
Timing:	Jan 30 2025 22:28:02
Script end

Main resources:

Total runtime	0.0233 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	588.2344	151.2109
Module start 'layout'	0.0049	0.0037	739.4453	220.6875
Module start 'content'	0.0086	0.0131	960.1328	997.8203
Module end 'content'	0.0217	0.0015	1,957.9531	29.9922
Script end	0.0233		1,987.9453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	11.1526	14	0.0002
Check MTime	0.0010	4.3331	14	0.0001
Mysql Total
Database connection	0.0008	3.2312	1	0.0008
Mysqli_queries	0.0023	10.0466	3	0.0008
Looping result	0.0000	0.0430	1	0.0000
Template Total	0.0011	4.8	1	0.0011
Template load	0.0009	3.8799	1	0.0009
Template processing	0.0002	0.8666	1	0.0002
Override
Cache load	0.0006	2.7851	1	0.0006
General
dbfile	0.0021	9.0531	8	0.0003
String conversion	0.0000	0.0307	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs