Create a database that you want to use for your store. You can create a
new one using MySQL wizard in your cPanel or control panel or use an
existing one. Note down the database server name (usually it is 'localhost'),
your database name, database username and database password. Keep it ready
as it will be required in the next steps.
First log in to your cPanel control panel or similar control panel
provided by your hosting company. Then go to the MySQL wizard.
Now enter the name of your database and click on 'Create Database'
button.
Make sure that the success message is shown.
Now go back to the wizard page and create a user for your database. Enter
a password for the user. Note down these details somewhere as they are
required for the next steps.
One last step left now - add the newly created user to the database.
Make sure you give this user all the rights.
Your database and user for it is now ready. Move to the next step.
Now create the database structure required for the application in MySQL
using phpMyAdmin utility. There may be other ways of creating the database
definition but this installation guide will show you how to do it using
phpMyAdmin (standard utility available with most of the hosting service
providers).
Go to the phpMyAdmin utility in your cPanel. Clicking on the phpMyAdmin
icon will typically open a new window.
You should see the newly created database on the left hand menu. Click on
the database name. Some versions of phpMyAdmin will give a dropdown. Select
the database from the dropdown in this case.
First you will see an empty database. Click on the Import button in the
right menu.
Now we are going to import the database definition and structures from
the file that has come with your ZIP package. To use this file click on the
'Browse' button.
Once the file selection pop-up appears, select the file 'store_tables.sql'
from the folder where you have unzipped the files.
Once the file is selected, make sure other options are also selected as
shown in the image below and then click on the 'Go' button towards the
bottom of the page.
Make sure you see the success message after the file upload and the
database tables created in the left column as shown below.
Close phpMyAdmin utility.