How To Use Database Wizard To Create A Database In cPanel

The cPanel MySQL Database Wizard is designed to guide you through the setup of a MySQL® database, user accounts, and user privileges. 

As a new cPanel user, this is the recommended way to create your first database and user.

MySQL Database Wizard 

  • Login to cPanel
  • In the New Database text box, enter a name for the database and click Next Step.
  • In the Username text box, enter a name for the user who you wish to allow to manage the database.
  • Enter and confirm the new password in the appropriate text boxes.
  • Click Create User.
  • Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.
  • Click Next Step.

 

After you complete the database setup process, select one of the following options:

  • Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.
  • Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.
  • Return to Home — Click to return to the cPanel Home interface.

Please note that when you use the MySQL Database Wizard interface to add a user and a database, the system automatically grants the user access to the database.

So you do not need to use the Add User to Database feature in the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

 

PostgreSQL Database Wizard

This also was designed to help guide you through the setup of your first PostgreSQL® database, user accounts, and user privileges.

To create additional databases or users, use the PostgreSQL Databases interface (cPanel >> Home >> Databases >> PostgreSQL Databases).

 

  • Login to your cPanel
  • In the New Database text box, enter a name for the database and click Create Database.
  • In the Username text box, enter a name for the user who you wish to allow to manage the database.
  • Enter and confirm the new password in the appropriate text boxes.
  • Click Create User.
  • Review the User and Database names and click Submit to add the new user to the new database.

The system will display a message that states that the system set up the database and user account successfully.

 

After you complete the database setup process, select one of the following options:

  • Add another database — Click to return to the start of the PostgreSQL Database Wizard to add more databases.
  • Add another PostgreSQL Databases User — Click to open the PostgreSQL Databases interface (cPanel >> Home >> Databases >> PostgreSQL Databases) to create additional user accounts and assign them to a database.
  • Return to Home — Returns you to the cPanel Home interface.

Again, when you use the PostgreSQL Database Wizard to add a user and a database, the system automatically grants the user access to the database. 

Please do not use the Add User to Database feature in the PostgreSQL Databases interface (_cPanel >> Home >> Databases >> PostgreSQL Databases_).

 

  • Database, MySQL, PostgreSQL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How To Resolve The "Incorrect Format Parameter" In phpMyAdmin

If you are trying to import a database and meet the "Incorrect Format Parameter" error, it might...

Here Is The Correct Way To Create A Database In cPanel

We recommend that you do not use phpMyAdmin to create databases or database users. We suggest...

cPanel Remote MySQL and Web Hosting Magic

On any vanilla cPanel server, the cPanel Remote MySQL allows remote hosts (servers) to access the...