Creating a database for a new eZ installation

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).