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

This article 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 (cPanel):

Step 1 of 7

Start by accessing your Web Hosting dashboard.

 

Step 2 of 7

Select cPanel Admin in the account dashboard.

Dashboard

 

Step 3 of 7

Under the Databases section, select MySQL Database Wizard.

Databases

 

Step 4 of 7

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

Name

 

Step 5 of 7

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

Users

 

Step 6 of 7

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 7 of 7

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 11

Start by logging in to your 123 Reg Control Panel.

 

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 access.

Manage hosting domain

 

Step 5 of 11

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 6 of 11

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 7 of 11

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 8 of 11

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

zip your files

 

Step 9 of 11

Click on your database in the top left hand corner.

zip your files

 

Step 10 of 11

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 11 of 11
  • 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.