MySQL Database Setup Guide

This guide gives a brief overview of creating a database from within cPanel. The first part of the guide applies only to creating a database in cPanel. However, the second part describes how to setup the database table using phpMyAdmin. Most hosts provide the phpMyAdmin tool, the most popular tool for editing databases.

Your database will have four tables:

Designs_Main - this table holds the information for each saved design. It does not hold the design details, such as text, fonts, and colors, but rather the top-level information such as design ID, design name, type of product and email.
wePExtras - this table holds the usernames and passwords for the two admin pages (admin and printadmin).

1. Create Database

When you click on the create database button within cPanel you will see the dialog box below:

Type a database name. You will be given a warning if you use an invalid name (no special characters allowed).

2. Create a User for the DB

A database needs to have a user that has rights to access the database. The user is created from the following dialog box.

3. Assign User to DB

Now that you have a user and a database, you need to assign the database to the user with the following dialog box.

4. Create Table for Design Information

The database needs a table that will hold the saved design information. A table is similar to a spreadsheet with rows and columns. Once you are in phpMyAdmin you will see your database shown in the left panel. Click on the DB name and you will see an area in the center of the screen as shown below:

Click on the IMPORT tab and a another dialog box will appear. This dialog box allows you to browse for the sql file that we are going to upload. Browse to the "extras" folder that is in your wePrint Installer package and locate the Designs_Main.sql file. Once you have selected this file, click on the GO button. You will see some SQL code scroll through the window and when you go back to the main page you will see that there is a table - Designs_Main listed below the DB name in the left panel. Click on the table name and you will see the details of the table as shown below. If you see a table with the information shown below, you are finished with the database setup.

The table needs to have the following structure:

PLEASE NOTE: You will need the DB name, User name, and password during the wePrint Design Studio installation, so write them down for future reference. You can now go back to the Install Help Section.

4. Create Table for Admin Usernames and Passwords

The username and password for each admin page (admin and printadmin) need to be stored in the database as follows:

Create a table named: wePExtras
Create 3 columns within the table

admin_page charvar(12)
user_id charvar(12)
password charvar(4)