1.Log into cPanel account.
2. Under the Databases section and Click on the “MySQL databases Wizard” icon.
3. Here you have to enter name of the new database and then click Next Step.
4. Now, you have to create a username and password for the database.
5. While entering a password , Make sure you are using strong password. You can use the Password Generator.
6. Once done, click Create User.
7. In the next section, you have to decide which privileges the user has.
8. If you are a website administrator and are creating a database for yourself to manage, check the All Privileges box at the top of the page.
Note : If you are creating a username for someone else, check the privileges they want.
9. then , click on Next Step.
10. Now you have finished setting up the new MySQL database, created a username and password to manage it, and assigned privileges to that user.
11.The final page of the Database Wizard (see below) gives you options to perform several related tasks.
That’s it!! If you have basic knowledge of cPanel’s Interface then you can easily understand above steps.