> ## Documentation Index
> Fetch the complete documentation index at: https://help.noxity.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Wizard

> Create a database, a user, and assign privileges in one guided four-step flow.

The Database Wizard bundles the three things you almost always do together (create a database, create a user, link them) into a four-step form. Faster than [Manage My Databases](/web-hosting/cpanel/database-management/manage-databases) when you're starting clean.

Open it from cPanel home → **Databases** → **MySQL Database Wizard**.

<Frame caption="Database Wizard step 1: name the new database">
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step1-light.png" alt="Database Wizard step 1 with database name field" className="block dark:hidden" />

  <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step1-dark.png" alt="Database Wizard step 1 with database name field" className="hidden dark:block" />
</Frame>

## Run through the wizard

<Steps>
  <Step title="Name the database">
    Type a short name. cPanel prefixes it with your account username automatically, so `shop` becomes `username_shop`. Click **Next Step**.
  </Step>

  <Step title="Create a user">
    Username (also auto-prefixed) and password. Use the **Password Generator** if you don't have one ready. Copy the password to your password manager before clicking **Create User**. cPanel won't show it again.

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step2-light.png" alt="Database Wizard step 2 with username and password fields" className="block dark:hidden" />

      <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step2-dark.png" alt="Database Wizard step 2 with username and password fields" className="hidden dark:block" />
    </Frame>
  </Step>

  <Step title="Pick privileges">
    Check **ALL PRIVILEGES** at the top of the list for normal apps. Click **Next Step**.

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step3-light.png" alt="Database Wizard step 3 with privileges checklist" className="block dark:hidden" />

      <img src="https://mintlify.s3.us-west-1.amazonaws.com/noxity/images/cpanel/database-management/database-wizard/step3-dark.png" alt="Database Wizard step 3 with privileges checklist" className="hidden dark:block" />
    </Frame>
  </Step>

  <Step title="Done">
    Confirmation screen with the database name, the user, and the privileges granted. Plug the values into your app's config.

    | Where it ends up | Value                     |
    | ---------------- | ------------------------- |
    | Database host    | `localhost`               |
    | Database name    | `username_yourdbname`     |
    | Database user    | `username_yourusername`   |
    | Password         | The one you set in step 2 |
  </Step>
</Steps>

## When to use the wizard vs Manage My Databases

| Wizard wins                        | Manage My Databases wins                     |
| ---------------------------------- | -------------------------------------------- |
| Spinning up a new app from scratch | Adding a second user to an existing database |
| You want one form, not three       | Renaming, repairing, or deleting             |
| You'll set ALL PRIVILEGES anyway   | You need fine-grained privilege control      |

## Need a hand?

<CardGroup cols={2}>
  <Card title="Open a ticket" icon="life-ring" href="https://members.noxity.io/submitticket.php">
    Best for anything that needs an account check or a config change on our end.
  </Card>

  <Card title="Live chat" icon="messages" href="https://noxity.io/contact">
    Faster for quick questions during business hours.
  </Card>
</CardGroup>