Creating a database for a new eZ installation

Next topic

Author	Message
stig henning	Friday 12 December 2003 8:22:52 am I installed ezpublish-3.2-2.tar.gz and found that when I needed to select a database, I had to use one of that already exists. Why doesn't eZ create a database itself ? How can I create a database for eZ ?
stig henning	Friday 12 December 2003 8:35:54 am http://ez.no/developer/ez_publish_3/documentation/installation/normal_installation/installing_ez_publish_on_a_linuxunix_based_system ------------ 1. Login as root: mysql -u <mysql_username> -p <mysql_password> 2. The MySQL client should display a "mysql>" prompt; create a new database: mysql> create database <database> 3. Grant permissions: mysql> grant all on <database>.* to <username>@<host> identified by '<password>'; <mysql_username>: The MySQL user (if no user is set up, use "root"). <mysql_password>: The password that belongs to the mysql_username. <username>: The username that will be used to access the database. <password>: The password you wish to set in order to limit access to the database. <database>: The name of the database, for example "my_new_database". <host>: The hostname of the server on which eZ publish will be running. (may be 'localhost' if MySQL is installed on the same server).

Author

Message

Friday 12 December 2003 8:22:52 am

I installed ezpublish-3.2-2.tar.gz and found that when I needed to select a database, I had to use one of that already exists.

Why doesn't eZ create a database itself ?

How can I create a database for eZ ?

stig henning

Friday 12 December 2003 8:35:54 am

http://ez.no/developer/ez_publish_3/documentation/installation/normal_installation/installing_ez_publish_on_a_linuxunix_based_system

------------
1. Login as root:

mysql -u <mysql_username> -p <mysql_password>

2. The MySQL client should display a "mysql>" prompt; create a new database:

mysql> create database <database>

3. Grant permissions:

mysql> grant all on <database>.* to <username>@<host> identified by '<password>';

<mysql_username>: The MySQL user (if no user is set up, use "root").
<mysql_password>: The password that belongs to the mysql_username.
<username>: The username that will be used to access the database.
<password>: The password you wish to set in order to limit access to the database.
<database>: The name of the database, for example "my_new_database".
<host>: The hostname of the server on which eZ publish will be running.
(may be 'localhost' if MySQL is installed on the same server).

eZ debug

Timing:	Jan 31 2025 06:15:38
Script start
Timing:	Jan 31 2025 06:15:38
Module start 'layout'
Timing:	Jan 31 2025 06:15:38
Module start 'content'
Timing:	Jan 31 2025 06:15:38
Module end 'content'
Timing:	Jan 31 2025 06:15:38
Script end

Main resources:

Total runtime	0.0217 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	588.3828	151.2422
Module start 'layout'	0.0048	0.0099	739.6250	36.7109
Module start 'content'	0.0146	0.0058	776.3359	90.1094
Module end 'content'	0.0204	0.0013	866.4453	29.9922
Script end	0.0217		896.4375

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	10.0786	14	0.0002
Check MTime	0.0010	4.6777	14	0.0001
Mysql Total
Database connection	0.0007	3.1843	1	0.0007
Mysqli_queries	0.0029	13.4878	3	0.0010
Looping result	0.0000	0.0636	1	0.0000
Template Total	0.0010	4.6	1	0.0010
Template load	0.0008	3.6781	1	0.0008
Template processing	0.0002	0.8701	1	0.0002
Override
Cache load	0.0006	2.7289	1	0.0006
General
dbfile	0.0014	6.6364	8	0.0002
String conversion	0.0000	0.0351	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