How do I create/edit/delete tables in my database?

We recommend you backup your databases before making any changes.

If you haven't already created a database then you will need to create one.

Creating a database:

  1. Login to cPanel.
  2. Click on "MySQL Databases" under the "Databases" section.
  3. Enter the name you wish to name your database, be aware that in most cases it will be prefixed with "username_".
  4. Click "Create Database".

Creating a table:

  1. Login to cPanel.
  2. Click on "phpMyAdmin" under the "Databases" section.
  3. 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.
  4. 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".
  5. The next page is setting the name and content of the columns in your table. Fill this information in and then click "Save".
  6. 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:

  1. Login to cPanel.
  2. Click on "phpMyAdmin" under the "Databases" section.
  3. 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.
  4. 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.
  5. Click on the name of the table you wish to edit.
  6. Click on "Structure" on the top menu.
  7. On this page it will give you lots of editing options for the table you have selected.

Deleting a table:

  1. Login to cPanel.
  2. Click on "phpMyAdmin" under the "Databases" section.
  3. 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.
  4. Click on the database name that includes the table you wish to delete.
  5. 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.

Is article helpful?