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.

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.
   
   File not found.
   
   

    Tip

   By default, Tiki uses UTF-8 for your database encoding. If you select a different encoding method, you may need to manually update your ../db/local.php file.
   
   

    Warning

   Use only alpha-numeric characters for the database name. Do not include any spaces in the name.
3. phpMyAdmin creates the database.
   
   File not found.
   
   

    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.
   No image specified. One of the following parameters must be set: fileId, randomGalleryId, fgalId, attId, id, or src.
3. Click the Add a new user link.
   No image specified. One of the following parameters must be set: fileId, randomGalleryId, fgalId, attId, id, or src.
4. Enter the following information in each field on the Add a New User page.
   
   File not found.
   • 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, select the following:
   • Data: Select all.
   • Structure: Select all:
   • Administration: Select LOCK TABLES.
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.
   
   File not found.
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 Tiki.