1- Login to your cPanel account
2- Search for Databases management section and then choose “MySQL Databases” and you will be redirected to databases management page, enter the database name and then click on “Create Database” as you see in the following screenshot:
3- Scroll down on the same page so you can create database username, enter username and password then click on “Create user” as you see in the following screenshot:
4- Scroll down on the same page to add this username to the database you have created earlier, choose the database and username then click on “Add” as you see in the following screenshot:
You will be redirected to another page to manage user privileges over this database as you see in the following screenshot: