create a mysql database
Create a MySQL Database
Log into cPanel. Under Databases, click MySQL Databases. In the New Database field, type a name for the database. Click Create Database. Click Go Back. The new database will appear in the Current Databases table.
Create a Database User
Log into cPanel. Under Databases, click MySQL Databases. Click to MySQL Users in the top-right corner of the page. Under Add New User, enter a username. Enter a password in the Password field. For generating strong password, click the Generate Password button. Retype the password and Click Create User button.
You will be redirected to a screen where you will be prompted to choose the desired privileges. It is advisable to select All Privileges and click on the Make Changes button.