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.
The below video and step by step instructions will help you to create a database.
Title: What is a database and how do I create one?
This video will look at what a database is and how you can create one using your Web Hosting control panel.
What is a database?
For those who don’t know, a database is used to store information for websites, blogs, forums and can also be used to store your client or customer information.
It’s made up of tables and fields, and if you had a database for let’s say, your blog, then it would contain information regarding your posts and different blog pages.
Please note that databases are only included in Business and Professional hosting packages.
Log into 123 Reg control panel
Ok, so if you haven’t already, log into your 123 Reg control panel using your username and password.
In the Web Hosting section, select your web hosting package and then click on the manage button.
This is your Web Hosting control panel.
In the Web Tools section, click on the MySQL Databases button.
If you have a Windows hosting package, you have a choice for which type of database you would like to set up.
We’ll be creating a MySQL database now, but if you choose to create a Microsoft SQL Database the steps are the same so you can follow along with us.
Ok so here is where you can create a database.
First you will need to create a username; this will also act as the name of your database, so it’s best to name it something which is relevant to your database.
When creating your username please ensure that it is 9 characters or less, and only contains letters, numbers or these characters.
When creating your username make sure that it contains:
9 characters or less
Only letters, numbers and “_” or “-“
Username cannot start or end with “-“
Cannot contain the words “test” “root” “mysql” or “alive”)
Once you’ve created your username, you will need to create a password, and this must be at least 6 characters long.
You can also have one generated for you by our system, just click on the generate button, but remember to note down the password.
Ok, now click here to create your database.
You will see that your database is listed in this section.
To log in and manage your database, simply enter the password you just created and then click on manage.
This will open up phpMyAdmin where you can begin creating tables for your database, and even import a database you have already created.
If you’ve selected to create a Microsoft SQL database, you’ll be able to begin adding tables just here.
Well that’s it; we’ve learnt what a database is and how to set one up.
Why not check out some more videos on databases, maybe you need help importing or exporting one?
Step 1 of 10
Log in to your 123 Reg control panel
Step 2 of 10
Scroll down to the Web hosting section.
Step 3 of 10
Select your domain name using the drop-down menu and then click on the Manage button.
Step 4 of 10
In the Web Tools section, click on either the MySQL or Microsoft SQL Databases button depending on whether you have a Windows or Linux Hosting package.
Step 5 of 10
You will need to create a username and password for your database and then click on the Create button.
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 6 of 10
You will now see your database in the Manage MySQL Databases section. Enter your password and click on the Manage button.
Step 7 of 10
This will open up phpMyAdmin.
Step 8 of 10
Click on your database in the top left hand corner.
Step 9 of 10
You can now start adding tables into your database.
If you created a Microsoft SQL database, you will not be logged into phpMyAdmin
Step 10 of 10
You can add in a new table by click on the Table button.
