What is a Database and how do I add one on my hosting package?

This FAQ will help you to create a MySQL or Microsoft SQL Database.

A database is used to store information for websites, blogs and forums, and can also be used to store your customers’ information. The step by step instructions below will help you to create a database.

The following steps apply to Web Hosting plans purchased after July 2020 and Premium Hosting plans purchased after August 2020:

Step 1 of 9

Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select Manage.

General Control Panel

 

Step 2 of 9

On the next page, select Manage for the account you wish to use.

Web Hosting Manage

 

Step 3 of 9

Select the three-dot icon for the package you want to edit. From there, choose Settings from the drop-down menu that appears.

cPanel Admin

 

Step 4 of 9

Select cPanel Admin in the account dashboard.

Dashboard

 

Step 5 of 9

Under the Databases section, select MySQL Database Wizard.

Databases

 

Step 6 of 9

Start by giving your database a name. Once done, click Next Step.

Name

 

Step 7 of 9

On the next page, create your users by entering their details and then select Create User.

Users

 

Step 8 of 9

On the next page, set which privileges you’d like the user to be able to perform. If you want them to be able to perform all privileges, select the ‘All Privileges’ box at the top. Once done, click Next Step.

Privileges

 

Step 9 of 9

You’ll then be shown a message confirmed that the user was successfully created. You can then choose whether to add another database or user by selecting one of the options below.
Complete

 

The following steps apply to Web Hosting plans purchased before July 2020 and Premium Hosting plans purchased before August 2020:

Step 1 of 9

Log in to your 123 Reg Control Panel

 

Step 2 of 9

Scroll down to the Web Hosting section, select your domain name using the drop-down menu and then click on the Manage button.

Control Panel Manage Button

 

Step 3 of 9

In the Web Tools section, click the ‘MySQL Databases’ option if you have a Linux Hosting package or ‘Microsoft SQL Databases’ if you have a Windows Hosting package.

click on the databases button

 

Step 4 of 9

You will need to create a username and password for your database and then click on the Create button.

create username

Please note: Your username should be 9 characters or less and can only contain letters, numbers and these characters: "_" and "-". It should not contain the words "test", "root", "mysql" nor "alive"

 

Step 5 of 9

You will now see your database in the Manage MySQL Databases section. Enter your password and select the Manage button.

click on the manage button

 

Step 6 of 9

This will open phpMyAdmin. Click on your database in the top left-hand corner.

zip your files

 

Step 7 of 9

Click on your database in the top left hand corner.

zip your files

 

Step 8 of 9

You can now start adding tables into your database.

add a table

If you created a Microsoft SQL database, you will not be logged into phpMyAdmin

 

Step 9 of 9
  • You can add in a new table by click on the Table button.add a table

Need more help with databases? See how to import or export a database.