Follow our tutorial for step-by-step guidelines on how to open a new database and database user in cPanel. You can do this through your Control Panel (cPanel) Dashboard, using the MySQL Database Wizard tool.

What is MySQL?

MySQL is a very popular open-source relational database management software program that is recommended for use with WordPress.

All your WordPress users, posts, pages, settings, e.t.c., are stored in your MySQL database. Thus, one of the first steps running a WordPress site is to create a new Database and Database User in Cpanel.

Steps to create a new database and database user in cPanel

Step 1

Login to your hosting cPanel with the login credentials that have been given to you by your hosting company.

Login to your hosting cPanel - Create new database and database user in cPanel

Step 2

Navigate to the “Database” section and click on the icon called “MySQL Database Wizard.”

Navigate to the “Database” - Create new database and database user in cPanel

Step 3

Allocate a name to your new database.

Allocate a name - Create new database and database user in cPanel

Step 4

Select a password for the new database user – make this as secure as possible and keep a safe record of this information for later. Click on the “Create User” button.

Select a password - Create new database and database user in cPanel

Step 5

Click on the “All Privileges” box.

All Privileges - Create new database and database user in cPanel

Step 6

Click on the “Next Step” button. This assigns all privileges to the new database user that you have just created.

Next Step - Create new database and database user in cPanel

Step 7

You will now receive a notification that the user has been added to the database.

user has been added - Create new database and database user in cPanel

Step 8

Now you need to edit the WordPress Config file. Open the file called wp-config-sample.php using a text editor.

Config file - Create new database and database user in cPanel

Step 9

You need to provide the following information. Be sure to include all of the prefixes as assigned by cPanel:

  • MySQL settings, which you can obtain from your web host
  • The name of the new WordPress database
  • The MySQL database username
  • The MySQL database password
  • The DB_Host, which is almost always localhost for cPanel hosts.

provide the following information

Step 10

Save the completed information file as as wp-config.php. That’s it – the new database and user have now been created, assigned the correct level of privileges and saved.

Save the completed information file