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.
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.
