Back to knowledgebase

How to Create a Database with Database Wizard in cPanel

Database Wizard screen in cPanel

Start the Wizard

  1. Go to Databases > Database Wizard.
  2. Enter a name for the new database.
Database name entered in Database Wizard
  1. Click Next Step.

Create the Database User

  1. Enter a username for the database user.
  2. Enter and confirm a strong password.
Create database user screen
  1. Click Create User.

Set the User Privileges

  1. Tick All Privileges if the website needs full access to the database.
  2. Or tick only the individual privileges the user needs.
Database user privileges screen
  1. Click Next Step.

Finish

  1. Check the confirmation message.
  2. Make a note of the full database name and full database username.
  3. Use those details in your website or application configuration file.

Notes

  • cPanel adds your account prefix to database names and usernames.
  • Database Wizard is the quickest option when you need a new database and user at the same time.