Installing the WEC Starter Package
Creating the Database
The fourth step is to create a MySQL database where the TYPO3 content management system will store configuration data and content for your website. This step can vary greatly from system to system and is largely dependent on what control panel (if any) you have available. A control panel is a web-based interface that helps you manage your web server.
If you have a control panel or a web-based database tool, such as PHPMyAdmin, installed on your server, it is highly recommended that you use it to create databases. Also, please note that your control panel may use specific naming conventions when creating databases and if these naming conventions are not followed then their automatic backup scripts will not backup your database. So, it is important to understand how your control panel works.
Create a database using any control panel or web-based database tool
If possible, create a new database and a new database user. If you have an existing database and database user, then that can be used as well. A new database is better because it avoids potential conflicts with duplicate table names and improves security.
Use your control panel or web-based database tool to create a new database.
Create a database user (and password) and give that database user full access (Select ALL privileges) to the new database.
Do not worry about adding tables or data to the database. That will be taken care of by the 1-2-3 Install Tool in the next step.
Create a database via cPanel
This section contains detailed instructions for users of the popular cPanel control panel. If your hosting provider does not provide cPanel on your web server then you can skip past this section. Or, if you use another control panel, you can follow the general process anyway because other control panels frequently offer similar functionality for creating and managing MySQL databases. Further information can be obtained from your control panel's documentation or from your web hosting support staff.
If you would like to add cPanel to your server, you can obtain a license from an authorized cPanel distributor or a test license by making a license request in the support section of www.cpanel.net.
To create a MySQL database using cPanel:
Use a web browser to login to your web server cPanel account. The web address for cPanel may vary but usually looks something like this www.mychurch.org/cpanel. Logging in will require a username and password.
The control panel “welcome page” will display. See below for an example of cPanel's welcome page.
If a database user has not already been defined, add a new database user. Under the Users heading, enter a database Username and Password. Click the Add User button. (see below) Click the [Go Back] link on the confirmation message to return to the “MySQL Account Maintenance” window.
Under the Databases heading, enter a database name, such as wectypo3, and click the Add Db button. (see below) Click the [Go Back] link on the confirmation message to return to the “MySQL Account Maintenance” window.
Select a User and Database and for , select the ALL checkbox. Click the Add User to Db button. (see below) Click the [Go Back] link on the confirmation message to return to the “MySQL Account Maintenance” window.
The cPanel window now will show that the user has access to the database. (see below)
Create a database via SSH
If you do not have a web-based tool like cPanel, you should be able to create the database by running MySQL from the SSH command line.
To create a MySQL database using SSH:
Run the mysql command with the -u root and -p arguments. This will log you in as the user “root” and prompt you for the MySQL root password.
After the welcome message, run the create database command with the database name as the argument. The name “wectypo3” is used in the example below.
> ./mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 30 to server version: 4.0.24-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> create database wectypo3; > Query OK, 1 row affected (0.00 sec)
|
Grant a user all privileges on all tables in the database (as in “wectypo3.*”).
Limit the user to the localhost domain (as in “wectypo3user@localhost”). This means the user only can connect to the MySQL database from the local server computer. In the example below the database name is “wectypo3,” the user is “wectypo3user,” and the password is “mypass.”
> mysql> GRANT ALL PRIVILEGES ON wectypo3.* > -> TO wectypo3user@localhost > -> IDENTIFIED BY 'mypass'; > Query OK, 0 rows affected (0.00 sec)
|
   |
14 / 22 |
