How to Create a Database

Note: This feature is only available on Shared, VPS, and QS Dedicated hosting packages.

If you want to create a database, you can do so on directly on your hosting account. Databases can be used in conjunction or separately from your websites.

Creating a Database on Your Hosting Account

  1. Log in to the Account Control Center (ACC)
  2. In the left sidebar, click Databases
  3. In the drop-down, click Create a New Databasecreate new database image
  4. On this page, add the required information:
    • Database Name: This will be the name you use to identify your new database. The name will be appended to your current account username. The outcome will look like username_databaseName
    • Access Level: This defines what connections can be made to the database. If you choose Local Only, only local connections will be allowed. If you choose Local/Remote, remote connections will also be allowed.
    • Optimization Period: Select how often you want the database to be optimized. This can be Monthly, Biweekly, and Weekly.
  5. When finished, click Add Databaseadd databse

Your database will now be created. If created successfully,  the next page will display your new database information. Be sure to take note of the passwords and different username types that can be used to access the database. The different usernames have different access types:

  • Full access: This user can read, edit, and run the database
  • Read access: This user can only see the database
  • Read/write access: This user can see and edit the database

The different login types allow you to give out limited access if others need access to the database. This reduces the likelihood of errors and abuse. Even if you don’t think this situation applies to you, we recommend storing all the login information in a safe place, just in case.