Fresh new database

Previous topic

Setup & design

Next topic

Author	Message
Kevin polston	Friday 17 September 2004 10:22:53 am Hi I’m new to EzPublish so please excuse me if this has been asked and answered before. Basically I’m wonder how a new ‘fresh’ database gets ‘primed’ with an admin user and password? I created a new database using: a) mysql> create database <mydatabase>; b) mysql> grant all on .* to user@localhost identified by password; c) $> mysql –u user –ppassword mydatabase < …/kernel/sql/mysql/kernel_schema.sql d) $> mysql –u user –ppassword mydatabase < …/kernel/sql/mysql/cleandata.sql So far so good. But how can I now use the ezpublish user say, “mysite_admin” to administer the site as I don’t know the password to the database I’ve just created? Many thanks Kevin
Kåre Køhler Høvik	Sunday 19 September 2004 5:54:01 am Please see : http://ez.no/ez_publish/documentation/installation/manual_installation/manual_configuration_of_ez_publish If you still have any problems, please reply here. Kåre Høvik

Author

Message

Kevin polston

Friday 17 September 2004 10:22:53 am

Hi
I’m new to EzPublish so please excuse me if this has been asked and answered before.

Basically I’m wonder how a new ‘fresh’ database gets ‘primed’ with an admin user and password? I created a new database using:

a) mysql> create database <mydatabase>;
b) mysql> grant all on .* to user@localhost identified by password;
c) $> mysql –u user –ppassword mydatabase < …/kernel/sql/mysql/kernel_schema.sql
d) $> mysql –u user –ppassword mydatabase < …/kernel/sql/mysql/cleandata.sql

So far so good. But how can I now use the ezpublish user say, “mysite_admin” to administer the site as I don’t know the password to the database I’ve just created?

Many thanks
Kevin

Kåre Køhler Høvik

Sunday 19 September 2004 5:54:01 am

Please see : http://ez.no/ez_publish/documentation/installation/manual_installation/manual_configuration_of_ez_publish
If you still have any problems, please reply here.

Kåre Høvik

eZ debug

Timing:	Jan 31 2025 08:09:54
Script start
Timing:	Jan 31 2025 08:09:54
Module start 'layout'
Timing:	Jan 31 2025 08:09:54
Module start 'content'
Timing:	Jan 31 2025 08:09:54
Module end 'content'
Timing:	Jan 31 2025 08:09:54
Script end

Main resources:

Total runtime	0.0183 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.0063	588.1094	151.1953
Module start 'layout'	0.0063	0.0033	739.3047	36.6172
Module start 'content'	0.0097	0.0072	775.9219	90.1250
Module end 'content'	0.0169	0.0013	866.0469	29.9922
Script end	0.0182		896.0391

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	14.5341	14	0.0002
Check MTime	0.0012	6.5746	14	0.0001
Mysql Total
Database connection	0.0009	5.0083	1	0.0009
Mysqli_queries	0.0030	16.4737	3	0.0010
Looping result	0.0000	0.1305	1	0.0000
Template Total	0.0010	5.2	1	0.0010
Template load	0.0007	3.9863	1	0.0007
Template processing	0.0002	1.1995	1	0.0002
Override
Cache load	0.0005	2.6719	1	0.0005
General
dbfile	0.0019	10.1941	8	0.0002
String conversion	0.0000	0.0444	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