Create a database and its user with the cPanel wizard

cPanel's Database Wizard creates an empty database, a user and the assignment of its permissions. It is useful when you are going to install an application manually and need its connection details.

If an automatic installer has already created the database for your website, check its configuration first: creating another one does not move the existing data.

Create the database

1. Log in to cPanel from your hosting service.
2. Look for Database Wizard (in older versions, MySQL Database Wizard).
3. Enter a name that identifies the project and continue.
4. Note down the full name cPanel shows, including your account's prefix.

Create the user

Enter a username and generate a unique password. Save both in your password manager: the database password is not the one for the client area or for cPanel.

Use a different user for each application. That way you can change its credentials or permissions without affecting other projects sharing the hosting.

Assign the permissions

In the next step, confirm that the user and the database are the ones you have just created. Select the permissions your application needs and complete the wizard. Some applications need ALL PRIVILEGES on their own database to install or update their schema; that is not the same as administrative privileges on the server.

Creating the user without assigning it to the database is not enough for the application to connect. You can review or change that assignment later from Manage My Databases.

Configure and check the application

Use these details in its configuration:

The database is still empty. Continue with the application's installer or import an SQL file from phpMyAdmin if you are migrating data.

If Access denied appears, check the full names, the password and the permissions. If the application looks for tables that do not exist, check that the installation or import has finished and that you entered the right database.

You can also see the cPanel wizard reference.