# How to Use MySQL® Database Wizard

> Canonical: https://jethost.com/kb/how-to-use-mysql-database-wizard/ · Last modified: 2026-09-08T11:01:27+00:00

The MySQL Database Wizard in cPanel lets you create a database, add a user, and assign privileges in one guided flow. This article walks you through each step so you can complete the setup quickly and correctly.

## Step 1: Access the MySQL Database Wizard in cPanel

1. Log in to your cPanel account.
2. Scroll to the **Databases** section.
3. Click **MySQL Database Wizard**.

## Step 2: Create the database

2. In the **New Database** field, enter a descriptive name for your database. cPanel automatically adds your account username as a prefix (for example, `<em>accountname_appdb</em>`).
3. Click **Next Step**. A confirmation appears showing that the database has been created.

## Step 3: Create the database user

1. In the **Username** field, type a short, descriptive user name. The account prefix is added automatically.
2. Enter a strong password in both **Password** fields, or click **Password Generator** to create one.
3. Click **Create User**. You will see a notice that the user has been added.

## Step 4: Assign privileges to the user

1. On the **Set Privileges** screen, check **All Privileges** unless your application needs specific permissions only.
2. Click **Next Step** to apply the selected privileges.

## Step 5: Finish and verify

1. The **Complete the task** screen confirms that the database and user are linked.
2. Click **Return Home** or **Return to MySQL Databases**.
3. Under **Current Databases**, check that the new database appears with the correct user assigned.
4. Copy the database name, username, and password for your application’s configuration file (for example, `wp-config.php` in WordPress).

## Best practices

1.**Strong passwords.** Use complex passwords to help prevent unauthorized access.
2. **Descriptive names.** Choose names that make it easy to identify each database and user later.
3. **Credential storage.** Keep your database details in a secure password manager.
4. **Remove unused databases.** Deleting old databases reduces clutter and potential security risks.
5. **Regular backups.** Back up your databases before making major changes or updates.

This guide shows how to use the MySQL Database Wizard to set up a database and user in just a few clicks. If you have questions or run into problems, contact our Support Team for assistance.