If you haven't already created a database then you will need to create one.
We recommend you backup your databases before making any changes.
Creating a database:
- Login to cPanel.
- Click on "MySQL Databases" under the "Databases" section.
- Enter the name you wish to name your database, be aware that in most cases it will be prefixed with "username_".
- Click "Create Database".
Creating a table:
- Login to cPanel.
- Click on "phpMyAdmin" under the "Databases" section.
- Your
databases should appear in a list on the left hand panel under your
username, if not click on the plus next to your username.
- Click
on the name of the database you wish to create a table within. Under the
"Create table" heading fill in the name and columns boxes and then
click "Go".
- The next page is setting the name and content of the columns in your table. Fill this information in and then click "Save".
- Your
newly created table will now appear under the database in the left
column, if it does not then click the little plus to the left of the
database name.
Editing a table:
- Login to cPanel.
- Click on "phpMyAdmin" under the "Databases" section.
- Your
databases should appear in a list on the left hand panel under your
username, if not click on the plus next to your username.
- The
table you wish to edit should appear under the database it is in, if not
click the little plus to the left of the database name.
- Click on the name of the table you wish to edit.
- Click on "Structure" on the top menu.
- On this page it will give you lots of editing options for the table you have selected.
Deleting a table:
- Login to cPanel.
- Click on "phpMyAdmin" under the "Databases" section.
- Your
databases should appear in a list on the left hand panel under your
username, if not click on the plus next to your username.
- Click on the database name that includes the table you wish to delete.
- A
list of tables will appear in the main window, to the right of the
table will be a "Drop" option, clicking this will prompt you with a
warning box. If you do wish to delete this table then click OK.
If you require further assistance please contact our support team.