# Simplified database creation with the cPanel MySQL Wizard

## 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*](https://documentation.cpanel.net/display/68Docs/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, click your database type: `MySQL MariaDB`
3. Enter and confirm the new password in the appropriate text boxes.

   Notes:

   * 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](https://documentation.cpanel.net/display/68Docs/Password+and+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.*
   * For more information about user privileges, read the [MySQL documentation](http://dev.mysql.com/doc/).
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*](https://documentation.cpanel.net/display/68Docs/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.

{% hint style="info" %}
**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*).
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.vimzaa.com/cpanel-hosting/cpanel-managing-databases/simplified-database-creation-with-the-cpanel-mysql-wizard.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.