How do I administer a MySQL database?

This article applies to Web Hosting and Premium Hosting packages.

If you need to add, access or remove any tables, queries or data from the database that your website features run off (for example, running a blog or forum) you will need to administer your database.

If you wish to administer your MySQL database, you need to do this through phpMyAdmin within your hosting package.

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

From here, you can see a list of your MySQL databases in the left-hand menu. Simply select the database you wish to access.

Access MySQL database

 

Step 4 of 4

On the next page, you can be shown a list of tables within your database that you can browse and edit.

You can also add a new table by selecting Create table.

View tables

 

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

Step 1 of 6

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 6

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 6

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 6

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

Manage hosting domain

 

Step 5 of 6

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

 

Step 6 of 6

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