Database Wizard makes it easy to create databases and users without having to configure everything manually. This guide shows how to create a database, add a user, and give the user access to the database.
Overview
Database Wizard in cPanel helps you create a database and associated user in a few simple steps.
This option has several advantages:
* It creates a database and user simultaneously
* It assigns access rights during the layout
* It requires no technical experience
* It simplifies layouts of web pages and applications that use databases
When you finish this guide, you will know how to create a database, create a database user, and assign the necessary rights in cPanel.
Important information
When you use Database Wizard to create a database and a user, the user is automatically connected to the database. Therefore, you do not need to add the user manually via "Manage My Databases" afterwards.
Database names may contain most ASCII characters, but the following characters are not allowed:
* /
* "
* '
* `
Prerequisites
Before you start, make sure:
* You have access to cPanel
* Your Hosting Account supports MySQL or MariaDB
* You have access to Database Wizard in cPanel
Step 1: Log in to cPanel
If your hosting service supports cPanel, you can log in directly from the dashboard in the client area.
This is how you do it:
* Find your hosting service under the list of active services
* Click the button "Log in to cPanel"
* You are now automatically logged into cPanel without having to enter your username or password again
Step 2: Create a new database
Go to Database Wizard in cPanel.
In the New Database field, type the name of the database you want to create.
Click the Next Step to Continue.
Once the database is created, you will be redirected to the creation of database users.
💡 Tip: Select a database name that makes it easy to identify which website or application the database belongs to.
Step 3: Create a database user
In the Username field, enter a database username.
Create a secure password by manually entering a password, or by clicking on the Password Generator option to automatically generate a strong password
Confirm your password in the next field
Click on Create User when you're done.
⚠️ Important: Keep database username and the password in a secure location. You need this information when you connect the website or application to the database.
Step 4: Assigning rights to the user
5. Choose which rights the user should have in the database.
You can:
Choose individual rights
Or select ALL PRIVILEGES to provide full access to the database
💡 Tips: For most websites and applications, it is recommended to choose ALL PRIVILEGES, unless you have special security requirements.
6. Click Next Step to Complete the Layout.
When the process is finished, cPanel will show a confirmation that the database and user are created.
Further alternatives
Once the database is created, you can choose one of the following options:
Add another database – Create a new database
Add another user for your database – Create multiple users and connect them to databases
Return to Manage My Databases – Manage existing databases and users
Go back to Home – Return to the home page of cPanel
Summary
You have now learned how to create a MySQL or MariaDB database using Database Wizard in cPanel.
Using Database Wizard, you can quickly create databases, add users, and assign the necessary rights without complicated configuration. This makes it easier to set up web pages and applications that rely on databases.