How to Install a Database in cPanel

Step-by-Step Guide

1. 1

   Step 1: The first step is to find your way to the MySQL section.

   Log in to your CPanel account and the icon entitled MySQL Databases
   - it's the one with the little jumping dolphin and sports gold and aqua colors.
2. 2

   Step 2: Single-click the MySQL icon

   , In the very first section, you should see a dialog box entitled "New Database"
   
   I recommend sticking with all lowercase for your database name) ,,,, It should have 3 hotlinks to the right of it: "Delete"
   
   "Check" and "Repair"
   
   ,,,,,, Scroll down to the 3rd section entitled "Add Users To Your Databases"
   
   They should be entitled "User:" and to it's right "Database:" Click the down arrow for "User" and select the user you created in Step
   12. ,,,,, You may now use your newly-created database.
   
   Make a note of all 3 "names" you have created.
   
   Don't forget the underscores separating the CPanel User ID from the database and usernames.
   
   Thus if your CPanel ID is frick, and you created a database named frack, with a user named frock, and a password of fff1234, then you would have 3 separate "assets" related to this database.
   
   The database name: frick_frack, the database user: frick_frack (assuming you used the same name) and the password: fff1234
3. 3

   Step 3: MySQL Account Maintenance window shows up.

4. 4

   Step 4: Click inside the "New Database" dialog box and type the name of your database (note: Linux servers ARE case-sensitive.

5. 5

   Step 5: Click on the "Create Database" box to the right of "New Database"

6. 6

   Step 6: The MySQL Account Maintenance window now responds with "Database Created" and a sub-title of "Added the database <what you named it>"

7. 7

   Step 7: Click the "Go Back" button

8. 8

   Step 8: Your new database will now be displayed in the list.

9. 9

   Step 9: Scroll down to the second section: "Current Users"

10. 10

    Step 10: Type in a name of a user - I generally just make the same username as the database is entitled

11. 11

    Step 11: for convenience.

12. 12

    Step 12: Hit the (tab) key or click in the password box and assign the user a password

13. 13

    Step 13: Click the box to the right entitled "Create User"

14. 14

    Step 14: The MySQL Account Maintenance window now responds with "Account Created" and the sub-title "Added <username> with the password <pass you assigned>

15. 15

    Step 15: Click "Go Back" one more time

16. 16

    Step 16: Now for the final (and MOST often overlooked step in the entire process - Adding the new user to the database.

17. 17

    Step 17: Note the dropdown dialog boxes just under the title of the 3rd section.

18. 18

    Step 18: Now click the down arrow for "Database" and select the database you created in Step 5.

19. 19

    Step 19: Ensure that the "Privileges:" dialog boxes have just ONE box checked (unless instructed by your developer/hosting provider) - that of "ALL"

20. 20

    Step 20: Below all the dialog boxes in this 3rd section

21. 21

    Step 21: click on the button entitled "Add User To Database"

22. 22

    Step 22: MySQL Account Maintenance responds with "Account Added to Access List" with the sub-title "Added user <your user> to the database <your database>

Detailed Guide

About the Author