Hosting a database driven Website

Hosting a database Driven Website

 

Hosting a data base driven website on a Cpanel hosting as offered by Truehost is simple.

They only difference between hosting a non-database driven website and website driven website is that a database driven website require database set up and upload.

 

Setting up database for a website, during web hosting

 

Login to your Cpanel using credentials provided by Truehost Kenya.

Basically mean clicking on the Cpanel url http://www.yourdomain.com/cpanel or http://www.serveripaddress/~yourusername/cpanel

Input your username

Input your password

Login.

On successful login, proceed to click mysql databases icon in the Cpanel

Creating a database

Under create database

Give your database a name

Click create database

Database name will therefore be your username_newnameyouhavegiven

 

Adding User to a new database

Online databases do not use the root user as default on localhost (local development phpmyadmin)

 

Under add new user

Indicate username

Username should have fewer than 7 characters

Input a desired database password

I recommend to use password creator to have a strong password.

At this point make sure you have saved your database name, your database username and your database password in a text file for use in your website.

 

 

Adding user to your database

 

Under Add a User to a Database

Selected the user you have created

Select your database

Click Add to add

It prompts you for roles to issue you database user

You may select all

Then presses add to finalize.

 

 

Uploading Database

Make sure you have exported your database from your localhost (local development environment) to a .sql file or .zip file if you are dealing with large database.

 

From your Cpanel Home

Click on phpmyAdmin icon

It will open in a new tab

Choose the database created earlier from the left side panel

Click on the database

Click on import option

Browse the location of your exported database

Select database file to import

On Successful import – you will have uploaded your database

 

Upload the files in the normal way as illustrated in the upload of non-database driven website tutorial

Ensure database connection or config files of your website reflect the new database name, new database user, new database password

Server should remain localhost unless advised otherwise by Truehost team.

 

Bingo – u r live now.

 

  • 5 Users Found This Useful
Was this answer helpful?

Related Articles

How to upload website files to a Cpanel account

How to upload website files to a Cpanel account Having completed creating your website locally...

Designing a Wordpress website on Truehost Kenya

Designing a Wordpress website on Truehost Kenya Truehost Kenya has servers customized for...

How to transfer a Domain

Well, you are ever calling, emailing, texting your domain hosting company but you end up...

How to Manage Multiple Domains in One Account?

Managing multiple domains from one hosting account is easy but will require you to be careful and...

Search Engine Optimization

SEO which stands for Search Engine Optimization refers to the process of gathering and collecting...