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 documentation site contains complete information on other databases. Starting with Release 4, Tiki supports only MySQL 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.
    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.

 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:
  1. Create a database
  2. Create a database user.
  3. Assign the user to the database.
  4. Grant the user all privileges to the database.
Refer to the {DOCLINK(page=Installation)}Tiki documentation{DOCLINK} for details.

<HR>

Copyright

This guide is based on content originally published by KeyContent.org.

This guide is Copyright (C) 2007-2013, 2019 by Rick Sapir and others under a Creative Commons Attribution-Share Alike 4.0 License. Some rights reserved.

Essentially, you are are free:

Image

to Share — to copy, distribute and transmit the work
Image

to Remix — to adapt the work


Under the following conditions:

Image
Attribution. You must attribute the work to me, as the original licencor, but not in any way that suggests that I endorse you or your use of the work.
Fair attribution includes a return link to http://tikiforsmarties.com (for online use) and mention of primary author (Rick Sapir) and original publisher (KeyContent.org).
Image

Share Alike. If you alter, transform, or build upon this work, you may distribute the resulting work only under the same, similar or a compatible license.


Please read http://creativecommons.org/licenses/by-sa/3.0/legalcode for the full license.

Tiki®, TikiWiki® and the Tiki logo are registered trademarks of the Tiki Software Community Association, used with permission.