1. Home
  2. Databases
  3. How to Create a Database

How to Create a Database

Shared

VPS

Dedicated

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

Creating a Database on Your Hosting Account

Choose the tutorial that reflects your ACC interface type: 

Not sure what the difference is? See Which ACC Interface Am I Using? 

If you are using the Legacy Interface:

  1. Log in to the Account Control Center (ACC) at my.pair.com
  2. In the left sidebar, click Databases
  3. In the drop-down, click Create a New Database
  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.

  1. When finished, click Add Database

If you are using the New ACC Interface:

  1. Log in to the Account Control Center (ACC) at my.pair.com
  2. In the top navigation bar, click Databases
  3. Click the Create New Database button
  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.

When finished, click the Add Database button

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.

Updated on June 17, 2025

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support