When you are manually installing a CMS (Content Management System) on your webhosting account, you need to create a database prior to the CMS installation and configuration. Here are the steps on how to create a database in cPanel.
Login to your cPanel account.
Click MySql Databases.
Under Create New Database heading, type in the name for your database inside the text box and click Create Database button.
(Tip : Make the name of your database relevant to the CMS application and name of your website so that you can easily identify the database. This is very helpful in the future when you need to add or create databases for different websites or CMS.)
After clicking Create Database button, it would take you to a page. Take note of the database name. Copy-Paste it in notepad or write it on a piece of paper. You will need it later. Click Go Back .
Scroll Down, you will see that your newly created database is added to the database list under Current Databases. Now you need to create a user for that newly created database.
Under MySQL Users, type in your desired username inside the Username textbox. Next, you need a password for that user.
Type in your desired password in the Password textbox and confirm the password in the next box. ( I prefer generating a random password. Click on Generate Password button. Click Use Password button. Copy-paste the password in the same notepad file you used earlier in copying the Database Name. Click Close. You will see that both password textboxes are automatically filled up.)
Click Create User button. A page will show you that the user with the associated password is created. (Tip : It would be best to countercheck the displayed password and the password you copy-pasted earlier.) Click Go Back. Under Current Users, you would see that the newly created user is now listed. (Tip: Copy-paste the whole user line, usually “prefixed” with your cpanel user account, to the same notepad file you used earlier.) Now, you need to associate the user with the database.
Under Add User to Database, click on the first drop down list and select the User. Click on the second drop down list and select the database. Click Add button. It would take you to another page.
Click All Privileges to check all the box options. Click Make Changes button. A confirmation in the succeeding page would inform you that the user is added to the database. Click Go Back.
Under Current Database, you can verify that the user is now associated with the database you created.
Now, your database is ready to use. If you find this post helpful, please post a comment or reaction.