What is cPanel Database Wizard?
Database Wizard is a cPanel tool that guides you step by step to create a new MySQL database and a user, and to add the user to the database.
Unlike Manage My Databases, which gives you separate options, Database Wizard brings all the necessary steps together in one continuous process. This reduces mistakes and saves time.
How to create a new database with Database Wizard
Step 1: Create the database
-
Log in to cPanel and select MySQL Database Wizard.
-
In the first step, enter a name for the database.
-
cPanel will add a prefix (e.g.
user_dbname). -
Click Next Step.
Step 2: Create a user
-
Enter a username and password for the new database user.
-
A prefix is added here as well (e.g.
user_dbuser). -
Set a strong password with numbers, symbols and upper/lower case letters.
-
Click Create User.
Step 3: Assign privileges
-
In the next step, you will be asked which privileges you want to grant.
-
Select All Privileges for full access (usually required for a CMS).
-
If you want restricted privileges, tick only the actions you need (e.g. SELECT, INSERT).
-
Click Next Step.
Step 4: Completion
-
cPanel will show you a success message confirming that the database and the user have been created and connected.
-
From here you can go back either to Database Wizard for a new database or to phpMyAdmin to manage the content.
Practical examples
Example 1: Installing WordPress
-
Create the database
user_wpdbthrough Database Wizard. -
Create the user
user_wpuserwith All Privileges. -
During the WordPress installation, enter:
-
DB Name:
user_wpdb -
DB User:
user_wpuser -
Password: your password
-
DB Host:
localhost
-
Example 2: Creating a database for an e-shop
-
For WooCommerce or Magento, create a separate database so that it does not get “mixed up” with other applications in the same account.
Example 3: Restricted user for reporting
-
Create a user with SELECT privileges only, for tools that need access to the data without being able to change it.
Tips and best practices
-
Always use strong passwords for your MySQL users.
-
One database per application: avoid putting two CMSs in the same database.
-
All Privileges for a CMS (WordPress, Joomla, etc.), but restricted privileges for external applications.
-
Always take a backup before modifying databases. Use JetBackup for restore points.
-
Prefer utf8mb4 for better support of Greek characters and emojis.
Frequently Asked Questions
What is the difference between Database Wizard and Manage My Databases?
The Wizard does everything in consecutive steps, while Manage My Databases gives you separate options. For beginners, the Wizard is easier.
Can I create more users for the same database?
Yes, but this is done from Manage My Databases, not from the Wizard.
Which host should I enter when installing a CMS?
The host is usually localhost. On a VPS it may be an IP or hostname.
What do I do if I forget the database user's password?
You can change it from Manage My Databases → Current Users.
Conclusion
cPanel Database Wizard is the simplest and safest tool for creating MySQL databases and users. In just a few steps you have a new database ready, with a connected user and privileges, without worrying about missed steps. Ideal for installing a CMS, e-shops and custom applications.