How to create a database?

Home » Knowledge Base » Databases » How to create a database?

Databases are an important part of modern websites. They store all your website data (content, users, configuration). This is why we offer databases for all hosting plans, including the free plan. In this article, we will go through the process of database creation.

 

Creating a database on a shared plan

When using our shared hosting plans you will be able to create databases only from the Database Manager located in the Hosting Control Panel. The reason for this is due to the fact that you do not have root access to the server and you would not be able to send a command to the server that would create the database for you. This means that when manually installing an application that requires a database you would also have to manually create the database from the Database Manager.

 

How to create a database?

To do that you would first have to navigate to the Database Manager. The Database Manager can be found inside your Hosting Control Panel under the Hosting Tools menu. Once inside the Database Manager you will be presented with two options:

  • Create MySQL Database
  • Create PostgresSQL Database

Choose the database type that your website requires. After that, you will have to enter the name and the password for your database as shown in the picture below, and click Create Database.

 

Things you must know when creating a database

There are a couple of things you need to know before and after you create a database:

  1. The name of your database would always have your client ID as a prefix. For example, if your client ID is 123456 your database name will be 123456_database
  2. When you create a database a user is automatically created and assigned to it. The name of the username for your database would be the same as your database name. Following the above example, the username for the database 123456_database would be 123456_database
  3. You cannot create additional users for your database. Each database comes with one and only user which can manage it
  4. Our shared hosting database servers are running on separate servers. This means that when installing your application you will not be able to use localhost as a hostname for your database. Please make sure to check your Database Manager for the proper hostname
  5. Databases cannot be accessed remotely. You can only make changes to your database via a script uploaded to your hosting account or via the phpMyAdmin which can be accessed in the Database Manager

If you are having trouble with using our Database Manager you can look at our article here where we have described the section in detail.

Was this post helpful?

i

Relevant tags:

Connect

Latest posts:

How to Remove a Product in OpenCart

After installing OpenCart and logging in to the dashboard, you can start adding and removing products immediately. We have already covered how to add products in OpenCart, and in this article, we share simple steps to delete products from your store with only a few...

How to Add Products in OpenCart

The most important element in your OpenCart project is the products you will offer your site visitors. In the following paragraphs, we share how to add products to your OpenCart website.   How to Create Products in Opencart The process of adding new products in...

How to Log in to OpenCart

After you install OpenCart, you can log in to the platform and start working on your project right away. To log in, you should open the OpenCart login page and enter the credentials you chose when installing the CMS. This will open the platform’s admin panel. In the...

How to Install OpenCart

You can install OpenCart on every AwardSpace web hosting plan, including our free web hosting, shared hosting, and advanced AwardSpace services such as Semi-Dedicated Hosting and VPS hosting. Keep in mind that all of the AwardSpace hosting services are tailored to run...

How to Change My Last Name in Moodle

If you are asking yourself "How to change my last name in Moodle", then you are at the right place. This guide will walk you through the steps for changing your last name in Moodle while addressing common concerns like ratings and discussions.   How to Change My...



Create a website for free!


Free forever

Our Support Team is Here to Help

 

If you need any questions answered, don't hesitate and contact us. Click the button below and follow the instructions. You can expect an answer within an hour.

 

Contact AwardSpace

 

iNewest knowledge base articles

How to Remove a Product in OpenCart

After installing OpenCart and logging in to the dashboard, you can start adding and removing products immediately. We have already covered how to add products in OpenCart, and in this article, we share simple steps to delete products from your store with only a few...

How to Add Products in OpenCart

The most important element in your OpenCart project is the products you will offer your site visitors. In the following paragraphs, we share how to add products to your OpenCart website.   How to Create Products in Opencart The process of adding new products in...

How to Log in to OpenCart

After you install OpenCart, you can log in to the platform and start working on your project right away. To log in, you should open the OpenCart login page and enter the credentials you chose when installing the CMS. This will open the platform’s admin panel. In the...

How to Install OpenCart

You can install OpenCart on every AwardSpace web hosting plan, including our free web hosting, shared hosting, and advanced AwardSpace services such as Semi-Dedicated Hosting and VPS hosting. Keep in mind that all of the AwardSpace hosting services are tailored to run...

How to Change My Last Name in Moodle

If you are asking yourself "How to change my last name in Moodle", then you are at the right place. This guide will walk you through the steps for changing your last name in Moodle while addressing common concerns like ratings and discussions.   How to Change My...

How to Change Your Name in Moodle

Changing your name in Moodle is a very simple task and requires only a few minutes of your time.   How to Change My Name in Moodle The process is comprised of a few easy-to-follow steps:   Step 1: Log in to Moodle After installing the CMS, you should log in...

Even more web tutorials

Check out our web hosting knowledge base and the WordPress tutorials to learn more, and be better prepared for your website creation and maintenance journey.