1. Assuming you are in cPanel, click on MySQL® Database Wizard icon under DATABASES group.
2. Insert your database name in the provided field and click Next Step.
(No special character and no more than 8 characters are allowed).
3. Enter the database user and password you want to use for this database in
the given text boxes respectively. Click Next Step to continue.
4. At this stage, you may need to assign the privilege to this MySQL user .
The top of the table provides a checkbox option ALL PRIVILEGES allowing you to create the
database with all privileges, otherwise choose the available privileges in the two columns.
Click Next Step and you are done.
You could check the options descriptions below.