Step 1. Setting up the database

Step 1. Copy the phpMyAdmin folder to the Web root.

Location: /Library/Web Server/Documents

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

• Host (Here, Host means the MySQL server.)
• User
• Password
• Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Step 1. Copy the phpMyAdmin folder to the Web root.

Location: /Library/Web Server/Documents

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

• Host (Here, Host means the MySQL server.)
• User
• Password
• Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Step 1. Perform the installation according to the type of Linux distribution: RPM, Apt, or manual download.

Note: For more information about the correct installation procedure, visit www.phpmyadmin.net/home_page/downloads.php.

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

• Host (Here, Host means the MySQL server.)
• User
• Password
• Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Start the Oracle Database Configuration Assistant and follow the instructions.

Note: The following steps refer to the step number in the main window.

Step 1. Select Create a Database.

Step 2. Select General Purpose.

Step 3. In the Global Database Name box, enter a name for the database.

This is typically in the form [name].[domain].

Example: ENT9.COMPUTERNAME.

Notes: The maximum number of characters that can be entered for the database name is limited to 8. The SID (Oracle System ID) is automatically generated from the full name.

Step 4. Management Options: no changes necessary.

Step 5. Enter passwords for the database administrators.

Step 6. Choose the Storage mechanism, such as the default File System.

For more information, see About file storage.

Step 7. Select the Database File Locations:

Step 7a. Select Use Common Locations for all Database Files.

Step 7b. Select a directory where the data should be stored.

Step 8. Recovery configuration: no changes necessary.

Step 9. Database content: no changes necessary.

Step 10. Initialization parameters:

• Memory tab: no changes necessary
• Sizing tab: no changes necessary
• Character Sets tab: select Use Unicode (AL32UTF8) and select “UTF8 - ...” as the National Character Set.

Step 11. Database Storage: no changes necessary.

Step 12. Creation options: click Finish and wait for the database to be created (this may take a while).

Step 1. Access the Oracle Enterprise Manager by choosing All Programs > Oracle > Database Control - ENT9.

Notes: “ENT9” is an example of the name that was specified as part of creating the database (see above).

Step 2. Log in by connecting as "SYSDBA" and using username "SYS".

You are now logged in to Database Instance ENT9.COMPUTERNAME (or whatever name you specified when creating the database).

Step 3. Select the Administration tab followed by Table Spaces.

Step 4. Click Create.

Step 5. Enter a new table space name, preferably using the same name as the database, in this example ENT9.

Step 6. Click Add.

Step 7. Enter a file name for the table space.

Step 8. Click Continue.

Step 9. Click OK.

The table space is created.

Choose between creating a combined user or creating separate users.

Creating one combined user (root user)

Step 1. (Optional, if not logged in yet.) Log in to the appropriate Oracle Enterprise Manager with user name SYS and connect as SYSDBA.

Step 2. Select the Administration tab and create a new user.

Step 3. Enter Root as the name.

Step 4. Enter a password (twice).

Step 5. Choose the name of the created table space (in our example ENT9) as the default table space.

Step 6. Choose TEMP as temporary table space.

Step 7. In the Role tab, add the following roles:

• CONNECT
• SELECT_CATALOG_ROLE
• DBA
• CTXAPP

Step 8. In the System tab, add the following system privileges:

• CREATE PROCEDURE
• CREATE TRIGGER
• CREATE TYPE
• EXECUTE ANY PROCEDURE
• EXECUTE ANY TYPE
• SELECT ANY DICTIONARY
• SELECT ANY TABLE
• UNLIMITED TABLESPACE

Step 9. Click OK to add the user.

Creating separate users

Choose between creating a WoodWing user or a root user.

WoodWing user (a user who has limited database access and who cannot alter tables)

Step 1. (Optional, if not logged in yet.) Log in to the Oracle Enterprise Manager with user name SYS and connect as SYSDBA.

Step 2. Select the Administration tab.

Step 3. Select Users.

Step 4. Click Create.

Step 5. Enter WoodWing as the name.

Step 6. Enter a password (twice).

Step 7. Choose the name of the created table space (in our example ENT9) as the default table space.

Step 8. Choose TEMP as temporary table space.

Step 9. In the Role tab, add the role CONNECT (if not already added.)

Step 10. In the System tab, add the system privilege CREATE SYNONYM.

Step 11. Click OK to add the user.

Root user (one combined user)

See "Creating one combined user (root user)" above.

Note: Normal users of the system will typically use the WoodWing account to log in to the Oracle database. The Root account is needed for users who will do maintenance, especially for creating custom properties.