Creating a new database in CPanel is one of the major steps while installing WordPress or any other content management system.

In this tutorial, we will see how to create a new MYSQL database using CPanel with rest of the important steps.

The topics we will discuss include:

  1. Creating the database.
  2. Creating a user for the database.
  3. Assigning full user privileges.

The easiest method to create a new database is by using cPanel Database Wizard.

1. Creating the Database

  • Login to your web hosting account and click Manage Databases.

cpanel filemanager

  • Under Create New Database, enter a name and press Create Database button.

cpanel create database

  • The database has been created but a user must be assigned to it otherwise WordPress won’t install.

wordpress database requirements

2. Creating User for the Database

Under MySQL Users, Add a new user by filling in Username and Password fields. See how to choose strong passwords easy to remember

cpanel database user

Choose a strong user password at least 8-12 characters long.

Woopoo's Caution

3. Assigning Full User Privileges

  • The user has been created but it needs to be assigned to the database with full user privileges.
  • Under Add User to Database, select User and Database from the drop-down menus and press Add.

add user to database

  • Select All Privileges checkbox at the top. This will enable all options below.

databasse user

  • Press Make Changes button.

You have properly setup your database in CPanel. You may now proceed with your WordPress installation.

Additional Readings

Conclusion

Many new bloggers get stuck on database step while installing WordPress. We hope the steps above will give you a good idea of creating a new database in CPanel and make a smooth installation on the go.

Last thing, please don’t forget to share this article and follow us on Twitter and Facebook

Gimme a Share pleeeaase!

Pin It on Pinterest

Share This