How do I delete data from a table in my MySQL database?

This article applies to Web Hosting and Premium Hosting packages.

Warning: Once data has been deleted, there is no way to reverse the action unless you have a backup that you can restore the deleted data from. Please be aware that it is your responsibility to keep an up-to-date backup of your databases as your 123 Reg hosting package does not come with a backup service.

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 4

Start by accessing your Web Hosting dashboard.


Step 2 of 4

On your dashboard, select phpMyAdmin.

Select phpMyAdmin


Step 3 of 4

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

Select Database


Step 4 of 4

From here, you can clear the data from a table by selecting Empty. Alternatively, select Drop to delete it completely.

Empty Table


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

Step 1 of 10

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 10

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 10

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 10

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

Manage hosting domain


Step 5 of 10

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


Step 6 of 10

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


Step 7 of 10

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


Step 8 of 10

Select the Table that you want to delete the data from and press the Empty icon.


Step 9 of 10

If you browse to the table you can delete all of the data from the table by clicking on the Empty tab. If you wish to delete a single entry, click on the corresponding red x for the relevant record.


Step 10 of 10

When prompted click the OK button.

The table will now have been emptied.