How to create a database with Database Wizard in cPanel

Category: cPanel

cPanel Database Wizard guides you through creating a database, creating a user, and assigning privileges without using separate screens. Use it when you are installing a CMS, an online store, Moodle, or another application that asks for a MySQL database name, username, and password.

Before you close the wizard, save the full names shown by cPanel. On shared hosting, they usually include an account prefix, for example usuario_nombrebd and usuario_userdb.

Before you start

  • Have access to the cPanel account where the domain or application lives.
  • Choose a short name for the database and another one for a database user.
  • Use a strong password and save it in a secure password manager.
  • Confirm which permissions your application needs; CMS apps and online stores usually use all privileges on that database.

Create the database

  1. Log in to cPanel and find the Databases section.
  2. Open Database Wizard. In some older themes, you may see it as MySQL Database Wizard.
  3. Type the database name in the field on the first step.
  4. Click Next Step and copy the full name confirmed by cPanel, including the account prefix.

Create a database user and assign it

  1. On the second step, type the MySQL username.
  2. Generate or paste a strong password for that user.
  3. Save the password somewhere secure before you continue; you will need it in the installer or configuration file for your application.
  4. Click Create User or Next Step, depending on your cPanel version.
  5. Confirm that the wizard shows the database and user you just created.
  6. Continue to the screen where you assign user privileges for that database.

Choose privileges

  1. Select All Privileges if a CMS, an online store, Moodle, or another application will use the database and needs to create and modify tables.
  2. If your developer requested specific permissions, select only those permissions and keep the list for support.
  3. Click Next Step to complete the assignment.
  4. Review the final wizard message and write down the database, user, and password before you leave.

Verify that the connection is ready

  • Open MySQL Databases in cPanel and confirm that the database appears in the list.
  • Check that your database user appears assigned to that database.
  • If you are installing an application, paste the full database name, full username, and exact password.
  • If the installer asks for a database server, use localhost unless support gives you another value.

Common errors

  • The installer says it cannot connect to MySQL: the database or username is usually missing the prefix; copy the full name from cPanel.
  • The password is rejected even though it looks correct: generate a new password, update it for the MySQL user, and paste it again without extra spaces.
  • The application cannot create tables: go back to MySQL Databases, edit privileges for that MySQL user, and confirm the required permissions.

Still need help?

If this guide didn’t solve your issue, our team can help you via ticket.

Open ticket Go to my account