Install TomatoCMS manually using cPanel

From TomatoCMS Documentation

Step 1: Create database

First step, we will use cPanel to create a database, new database user and provide all privileges on the database for the user.

• From the cPanel administrator page, look at Databases section, and click on the MySQL databases link:

At the new page, enter tomatocms to New Database text field and click on the Create Database button:

After pressing the button, you will received the message informing that our database has been created successfully, click on the Go Back link:

• Next, look at Add New User section, fill the following information to the form:
  • tomato for Username field,
  • Click on Password Generator to generate the password, copy and paste the password to the password fields.

Don't forget to backup your password in somewhere else, because we will use it to configure TomatoCMS later

Click on the Create User button.

• Next, look at the Add User To Database section, select X_tomato from the list of users and X_tomatocms from the list of databases
  

(X might be different on your server, it is prefix and will be added to the beginning of all databases, all users)
Click on the Add button.

cPanel will redirect you to a new page that allows you to set the privileges on the selected database for selected user.
Select the Add Privileges check box and click on the Make Changes button:

Step 2: Import the sample data

Because we don't use Install Wizard, therefore we have to import the sample data that ensure all functions in the back-end section works.
From cPanel administrator page, click on the phpMyAdmin link inside the Databases section:

Click on the _tomatocms on the left side:

Then, on the right side, click on the Import link, choose the tomatocms_sample_db_mysql.sql file in install folder from the TomatoCMS folder that you download from TomatoCMS's official website

Finally, click on the Go button to start the importing process.
After importing, you can execute the following query to set the password for admin user:

UPDATE `core_user` SET password = md5('Your_New_Password') WHERE user_name = 'admin'

Step 3: Upload TomatoCMS to your server

• From cPanel administrator page, click on the File Manager in Files section.

Please check the Document Root for option and select your site or your sub-domain which you want to install TomatoCMS in:

Click on the Go button to continue.

• Click on the Upload icon at the toolbar of File Manager page.

Choose the TomatoCMS package that you already downloaded to your computer and cPanel will upload the file to server automatically.

• After uploading, we have to extract the uploaded files.

Select the check box associating with the uploaded file, click on the Extract button from the toolbar, define the directory that we want to extract files and click on the Extract Files button:

• All the TomatoCMS files will be extract to a directory named tomatocms. You have to move all files inside tomatocms directory to our website directory by:
  • Select the tomatocms directory on the left side,
  • Click on the Select All check box,
  • Click on the Move File button in the toolbar,
  • Define the target directory,
  • And, finally, click on Move Files button

• After moving files, don't forget to delete the tomatocms directory.

(Click on the check box associating with tomatocms directory, click on the Delete button in the toolbar, then, click on the Delete Files button)

Step 4: Configure TomatoCMS

Final step, open the /application/config/application.ini on the server and change the following settings based on your system:

[production]
resources.frontController.baseUrl = "/"
...
 
[db]
adapter = "pdo_mysql"
...
slave.server2.dbname = "Our_Database_Name"
slave.server2.username = "Our_Database_User"
slave.server2.password = "Our_Database_Password"
slave.server2.charset = "utf8"
master.server1.host = "localhost"
master.server1.port = "3306"
master.server1.dbname = "Our_Database_Name"
master.server1.username = "Our_Database_User"
master.server1.password = "Our_Database_Password"
master.server1.charset = "utf8"
 
[web]
url = "http://site.com"
...
static_server = "http://site.com"
...
 
[install]
date = "2010-08-10 09:00:00"
version = "2.0.7.1"

Come back to our website, and you will see that our site has been installed successfully. You can use the admin as username, the password that you set in step 2 to access the back-end section: http://site.com/admin