The MySQL Database Wizard in cPanel is the simplest and safest way to create a database.
It guides you through all required steps and prevents common mistakes.

This tool is recommended for beginners and for most Web Hosting and Site Hosting users.

What the Database Wizard Does #

The Database Wizard helps you:

• Create a new MySQL database
• Create a database user
• Set a password for that user
• Assign the user to the database with correct permissions

Without the wizard, these steps must be done manually and in the correct order.

Where to Find the Database Wizard #

1. Log in to cPanel
2. Go to the Databases section
3. Click MySQL Database Wizard

Step 1: Create a Database #

• Enter a name for your database
• Click Next Step

The database name will automatically include your cPanel username as a prefix.
This is normal and cannot be changed.

Example:
username_exampledb

Step 2: Create a Database User #

• Enter a username
• Create a strong password or use the password generator
• Click Create User

Write down the username and password.
You will need these later for your website configuration.

Step 3: Assign Permissions #

You will be asked which permissions the user should have.

For most websites and applications:

• Select All Privileges
• Click Make Changes

This allows the website to fully manage its own data.

Step 4: Finish Setup #

Once permissions are assigned, the database is ready to use.

You now have:

• A database
• A database user
• A user connected to the database

No further setup is required in cPanel.

Using the Database with Your Website #

To connect your website or application to the database, you will need:

• Database name
• Database username
• Database password
• Database host

The database host is usually localhost, unless stated otherwise.

These details must be entered into your website’s configuration file.

When to Use the Database Wizard #

Use the Database Wizard when:

• Installing WordPress manually
• Installing another CMS or web application
• You want a quick and correct setup

You may choose manual database management only if you know exactly what you are doing.

Common Mistakes #

• Forgetting to assign the user to the database
• Using an incorrect password in the website configuration
• Not selecting all privileges
• Losing the database login details

These issues can cause websites to fail to connect to the database.