Knowledgebase

Add a MySQL user

After you create a database, add users to the database and configure their privileges.

To create a new user account, perform the following steps:

1. Enter a username in the Username text box.

   Important:

   To learn more about database username limits, click your database type:

    

   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.

    

2. 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 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.

    

3. Click Create User.

4. Click Go Back to return to the main interface.