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.
What is a website database?
A web database is used to store information for websites, blogs and forums, and can also be used to store your customers’ information. You can even create your own database with our hosting packages.
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)
Select cPanel Admin in the account dashboard.
Under the Databases section, select MySQL Database Wizard.
Start by giving your database a name. Once done, click Next Step.
On the next page, create your users by entering their details and then select Create User.
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.
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.
Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020
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?
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.
This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.
On the next page, select Manage for the domain you wish to access.
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.
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"
You will now see your database in the Manage MySQL Databases section. Enter your password and select the Manage button.
This will open phpMyAdmin. Click on your database in the top left-hand corner.
Click on your database in the top left hand corner.
You can now start adding tables into your database.
If you created a Microsoft SQL database, you will not be logged into phpMyAdmin