• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Spain CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple, the Netherlands

Step 5 Database Information

We need your assistance to make the documentation accurate, user friendly and understandable. Therefore we welcome any tips or suggestions regarding documentation. Thank you in advance for your contribution.

However, we will not respond to technical support questions submitted using this form. If you are having difficulty with CMSMS and cannot find the solution on this website, please submit your question appropriately on our support forum at: http://forum.cmsmadesimple.org. Please remember to follow the forum rules when posting.


This is a captcha-picture. It is used to prevent mass-access by robots. (see: www.captcha.net) Please confirm that you are not a script by entering the letters from the image

Open anchor to this point in the page Site Name

This is the name of your site. It will be used in various places of the default templates and can be used anywhere with the {sitename} tag:

  1. {sitename}

This setting can be changed afterwards in the admin panel Siteadmin >> Global Settings

Open anchor to this point in the page Timezone

Some servers running PHP 5.3 do not have the timezone set correctly. Please select the appropriate timezone from the list below before proceeding. If this is not necessary on your server, you may select "None". Note: Please select your server's timezone; this is not a display setting, but is used in arithmetic related to times and dates.

This setting can be changed afterwards in the config.php file in the root of your website.

Open anchor to this point in the page Database Information

Make sure you have created your database and granted full privileges to a user to use that database.

The following instructions are for creating a database and a user of that database suitable for CMSMS. They assume you are using the mysql command line interface (CLI). Your hosting provider may provide some graphical mechanism for managing databases to make this task easier. The steps are essentially the same for each method.

1: create database cms;
2: grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass'

CMSMS Requires that the database user account have all privileges to the specified database. Even after installation.

In the installation gui you will need to fill in the fields using the information you provided when creating the database:

Open anchor to this point in the page Type:

There are usually two available options here (mysqli) and (mysql). We recommend for performance reasons you choose mysqli where possible.

Previous versions of CMSMS supported postgres. However, due to lack of usage this feature was dropped in CMSMS 1.10

Open anchor to this point in the page Database host address

Normally this is localhost. However your host instructions may state differently.

Open anchor to this point in the page Database name

This is the name you specified in the "create database" command. In the example above the database name was: cms.

Open anchor to this point in the page Username

This is the username you specified in the "grant all privileges..." command, or when creating a database user in your hosts graphical user interface. In the example above the username was: cms_user.

Open anchor to this point in the page Password

This is the password you specified in the "grant all privileges...." command, or when creating a database user in your hosts graphical user interface. In the example above the password was: cms_pass.

Open anchor to this point in the page Database port

This is used to connect to mysql over a non standard port number. If your database host is not running on a non standard port, or if you don't know, leave this blank and CMSMS will use default settings.

Open anchor to this point in the page Table prefix

Table prefixes are used when creating tables so that multiple applications can share the same database without the possibility of naming conflicts. You can even run multiple CMSMS installs from the same database by specifying a different table prefix.

The default value for the table prefix is cms_

Open anchor to this point in the page Create Tables (Warning: Deletes existing data)

This checkbox indicates wether CMSMS should attempt to drop and create tables. Normally this field should be checked at all times. Use caution when disabling this feature!

Open anchor to this point in the page Install sample content and templates

This checkbox indicates wether CMSMS should create sample content and templates in its tables. For a new installation this is highly recommended as the default content pages and templates have been documented to provide assistance for users new to CMSMS.

If you are moving a site, or having a problem with the config file you may want to try disabling this feature. It will force CMSMS to re-create the config file(s) and clear the cache, without touching the database tables.