How do I create a new table in my MySQL database?

This article applies to our Web Hosting and Premium Hosting packages.

Website software such as WordPress or Joomla that are used to create features such as blogs, forums and content management systems will automatically create the required tables for the function in your database. If your needs require you to additional tables, please do the following:

Simply click on a title below to skip to the most appropriate FAQ. You can also click the Top button to return and make another selection.

Web Hosting plans purchased after July 2020 / Premium Hosting plans purchased after August 2020 (cPanel)

Step 1 of 6

Start by accessing your Web Hosting dashboard.

 

Step 2 of 6

On your dashboard, select phpMyAdmin.

Select phpMyAdmin

 

Step 3 of 6

Select the database you wish to access from the left-hand menu.
Select Database

 

Step 4 of 6

Under the ‘Create table’ heading, enter the name you would to use for your table. From there, press Enter on your keyboard.

Enter table name

 

Step 5 of 6

You will next be asked to enter the settings for the table. You can add additional columns using the ’Add’ bar along the top. Once done, select Save to start creating your table.

Enter your table settings

 

Step 6 of 6

Once done, you’ll see an overview of your table’s data.

 

Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020

Step 1 of 11

Start by logging in to your legacy Control Panel. For details on how to do this, please read the following article: How do I access and manage my products?

Step 2 of 11

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

Manage Shared Web Hosting

 

Step 3 of 11

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting

 

Step 4 of 11

On the next page, select Manage for the domain you wish to update.

Manage hosting domain

 

Step 5 of 11

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

 

Step 6 of 11

In the Manage Databases section press the Manage button to access phpMyAdmin.

 

Step 7 of 11

If you have a blank database, click on the database name in the left hand frame.

 

Step 8 of 11

Type in the Name of the new table and how many fields you want to have (this can be changed later).

Then click the Go button.

 

Step 9 of 11

You will next be asked to enter the settings for the Table. Enter your settings then click on the Save button.

 

Step 10 of 11

You will get a confirmation that will show the SQL code that was used to create the table.

 

Step 11 of 11

An overview of the Table will be shown, also any additional information that is relevant to the table.