Knowledgebase

Overview:

Use this interface to create, manage, and delete MySQL® databases and database users.

• We recommend that you use cPanel’s MySQL Database Wizard interface (cPanel >> Home >> Databases >> MySQL Database Wizard) to create your first database and user.

• A database name may contain a maximum of 64 characters.

  • Due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two characters of that limit.

  • If you enable database prefixing, a database name may contain a maximum of 63 characters, which includes the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.

  • To enter information in an existing database, copy a database, or run MySQL queries and scripts, use cPanel’s phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin).

    Warning:

    Don’t use phpMyAdmin to create databases or database users. phpMyAdmin doesn’t map databases, which causes backups and restorations to not function.

     

Create a database

To create a database, perform the following steps:

1. In the New Database text box, enter a name for the database.

   Note:

   If your hosting provider has enabled database prefixing, a prefix based on your account username and underscore character ( _ ) will precede the New Database text box. The system automatically prepends this prefix to the database name.

    

2. Click Create Database. A new interface will appear.

3. Click Go Back. The new database appears in the Current Databases table.

To access and manage databases that you create, use the phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin). For information about how to use phpMyAdmin, visit the phpMyAdmin website.