Creating the Database

Now that you have the Tiki files on the web server, you need to create a database for Tiki to use. Tiki supports different types of databases (MySQL, Postgress, Oracle, etc.) through ADOdb, a database extraction library.

Note: This guide uses MySQL, the most common database used with Tiki. The Tiki Wiki documentation site contains complete information on other databases.

This procedure assumes that you are using phpMyAdmin, a popular application used to help administer MySQL databases.

1. Access your phpMyAdmin control panel.
2. In the Create New Database area, enter a name for your database and click Create.
   

   Figure: Creating a database.

   
   

   Warning: Use only alpha-numeric characters for the database name. Do no include any spaces in the name.

3. phpMyAdmin creates the database.
   

   Figure: Your new database.

   
   

   Note: Write down the name of your database — you will need it later.

Create a Database User

Now you need to create a user account that Tiki will use to access the database. This user is different than the users for your Tiki — this user will be used by Tiki.

1. Return to the phpMyAdmin Home page.
2. Click Privileges.
   
3. Click the Add a new user link.
   
4. Enter the following information in each field on the Add a New User page.
   

   Figure: Adding a new database user.

   • User name: Enter a username for this database user.
   • Password: Enter a password for this user name.
   • Re-type: Repeat the password.
   
   

   Warning: Select a strong password to protect your Tiki

   
   

   Note: Write down your database username and password — you will need them later.

5. In the Global privileges area, click Check All.
6. Click Go to create the database user.

Add the Database User to the Database

Now you need to give the database user (that you just created) access to the database (that you created earlier).

1. On the MySQL Databases page, find the Add Users to Database area.
   

   Figure: The Add User to Database area of the MySQL databases page.

2. Enter the following information in each field:
   • User: Select the database username that you created earlier.
   • Database: Select the database that you created earlier.
3. Select All privileges. Tiki will need full accesses to the database in order to run your website.
4. Click Submit.

Congratulations! your database is now ready for TikiWiki.

---

Note: Depending on how you access your database information (through your web host's control, phpMyAdmin application, or some other program), your actual screens may vary from those shown here. However, the basic process will be the same: Create a database Create a database user. Assign the user to the database. Grant the user all privileges to the database. Refer to the TikiWiki documentation for details.

---