MySQL Database Wizard  Print this Article

Overview:

This wizard guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user.

To create additional databases or users, you can also use the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

Set up a database

To set up a database, perform the following steps:

  1. In the New Database text box, enter a name for the database and click Next Step.

    Note:

    The system limits the database name to 64 characters. However, due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two characters of that limit. Therefore, if your hosting provider enabled database prefixing, the maximum length of the database name is 63 characters, which includes both the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.

     

  2. In the Username text box, enter a name for the user who you wish to allow to manage the database.

    Important:

    To learn more about database username limits, see below:

     

    MySQL

    MySQL limits the database username to 16 characters. The system includes the database prefix (the first eight characters of the cPanel account’s username and an underscore character) in the character count for the username.

    For example:

    • A MySQL database with the db_ prefix allows usernames that contain up to 13 characters.

    • A MySQL database with the example_ prefix allows usernames that contain up to eight characters.

     
    MariaDB

    MariaDB limits the database username to 47 characters. The system includes the database prefix (all of the cPanel account’s username and an underscore character) in the character count for the username.

    For example:

    • A MariaDB database with the db_ prefix allows usernames that contain up to 44 characters.

    • A MariaDB database with the example_ prefix allows usernames that contain up to 39 characters.

     

  3. Enter and confirm the new password in the appropriate text boxes.

    Note:
    • The system evaluates the password that you enter on a scale of 100 points. 0 indicates a weak password, while 100 indicates a very secure password.

    • Some web hosts require a minimum password strength. A green password Strength meter indicates that the password is equal to or greater than the required password strength.

    • Click Password Generator to generate a strong password. For more information, read our Password & Security documentation.

     

  4. Click Create User.

  5. Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.

  6. Click Next Step.

The system displays a message that states that you successfully set up the database and user account.

Additional options

After you complete the database setup process, select one of the following options:

  • Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.

  • Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.

  • Return to Home — Click to return to the cPanel Home interface.

Note:

When you use the MySQL Database Wizard interface to add a user and a database, the system automatically grants the user access to the database. You do not need to use the Add User to Database feature in the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

Was this answer helpful?

Related Articles

phpMyAdmin
phpMyAdmin is a third-party tool included with cPanel, used for manipulating MySQL databases over...
phpPgAdmin
phpPgAdmin is a third-party tool included with cPanel, used for manipulating PostgreSQL databases...
MySQL® Databases
Overview: Use this interface to create, manage, and delete MySQL® databases and database users....
PostgreSQL Database Wizard
Overview: This wizard guides you through the setup of a PostgreSQL® database, user accounts, and...
PostgreSQL Databases
Overview: Use this interface to create, manage, and delete PostgreSQL® databases and database...