Open a New Database and Database User in cPanel

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

Step 2

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

Step 3

Allocate a name to your new database.

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.

Step 5

Click on the “All Privileges” box.

Step 6

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

Step 7

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

Step 8

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

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.

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.