If you are a beginner, the MySQL Database Wizard will guide you how to create a MySQL database step by step.
To add a user to the MySQL database, follow the instructions below.
Procedure:
1. On the homepage of your cPanel, click the MySQL® Database Wizard
icon under Databases.
2. Enter the name of the database in the New Database field.
3. When you are done, click the Next Step button.
4. Enter a username in the Username field.
5. Enter a password in the Password field.
6. Enter the password again the Password (Again) field.
7. Click on the Next Step button.
8. Select the Privileges you wish to assign to the user or select All Privileges.
9. Click on the Next Step button.
10. The database is now created. The user is also successfully added to the database.
11. If you want add another MySQL database, click on the Add another database link. If you want to add another user to a MySQL database, click on the Add another user using the MySQL Databases Area. If you want to return to the cPanel home screen, click on the Return to Home link.