How to Create a Database Using the MySQL® Database Wizard in cPanel

Introduction

The MySQL® Database Wizard in cPanel is the fastest and easiest way to create a new MySQL database, set up a user, and assign permissions—all in one step. Whether you're installing WordPress, a CMS, or any script that requires a database, this tool helps you get started in minutes.

This guide walks you through how to use the wizard to set up a fully functioning database.

Why Use the MySQL® Database Wizard?

• Combines database and user creation in one flow

• Ideal for beginners and quick setups

• Ensures correct permissions are applied automatically

• Saves time compared to manual setup

Step-by-Step: Create a Database Using the Wizard

1. Access the Wizard

• Log in to your cPanel

• Scroll to the Databases section

• Click on MySQL® Database Wizard

2. Step 1: Create the Database

• Enter a name for your new database (e.g., site_db)

• Click Next Step

Your database is now created.

3. Step 2: Create Database User

• Enter a username (e.g., user1)

• Create a strong password (or click Password Generator)

• Confirm the password

• Click Create User

The database user is now created.

4. Step 3: Assign Privileges

• You’ll now assign the user to the database

• Select the permissions you want to give (check All Privileges for full access)

• Click Next Step

The user is now linked to the database with the selected permissions.

5. Done!

You will see a confirmation screen showing that:

• The database was created

• The user was added

• Permissions were applied successfully

You can now use this database information in your website or application’s configuration.

What’s Next?

• Use phpMyAdmin to manage tables and data

• Connect a script (like WordPress) using your database name, username, and password

• Secure your credentials in a safe place for future use

Tips

• Always use strong, unique passwords

• Grant only necessary privileges if the user doesn’t need full access

• Back up your database regularly

• Avoid using common names like test or admin for better security

Conclusion

The MySQL® Database Wizard in cPanel simplifies the entire process of database setup into a few quick steps. It’s the ideal tool for creating a database and assigning a user when setting up any dynamic website or app.