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:
Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select Manage.
On the next page, select Manage for the account you wish to use.
Select the three-dot icon for the package you want to edit. From there, choose Settings from the drop-down menu that appears.
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.
The following steps apply to Web Hosting plans purchased before July 2020 and Premium Hosting plans purchased before August 2020:
Scroll down to the Web Hosting section, select your domain name using the drop-down menu and then click on the Manage button.
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