Creating Databases

Expertise level: Easy

To create databases and its users, please use the following procedure:

1. Log in to your cPanel Interface.
2. Go to "Databases" section.
3. Click on "MySQL Databases".
4. Under "Create New Database" section, add the database name. Database name takes the form username_dbName.
5. Click on "Create Database" button.
6. Click on "Go Back" in order to return to previous page.
7. Under "MySQL users", you can add new users and their passwords.
8. Click "Create User".
9. Click on "Go Back" in order to return to previous page.
10. Under "Add User To Database" select the database and user from the drop-down menus.
11. Click on "Add".
12. Now you can give the necessary permissions to the user on the database by selecting the appropriate boxes.
13. Click on "Make changes".
    

Check the relevant screen captures: