1 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 - look for a jumping Dolphin icon. 2. Single-click the MySQL icon
3. MySQL Account Maintenance window shows up. In this section, you should see a dialog box entitled "New Database"
4. Click inside the "New Database" dialog box and type the name of your database (note: Linux servers ARE case-sensitive. I recommend sticking with all lower case for your database name)
5. Click on the "Create Database" box to the right of "New Database"
6. The MySQL Account Maintenance window now responds with "Database Created" and a sub-title of "Added the database (what you named it)"
7. Click the "Go Back" button
8. Your new database will now be displayed in the list. It should have 3 hotlinks to the right of it: "Delete" , "Check" and "Repair"
9. Scroll down to the second section: "Current Users"
10. Type in a name of a user - I generally just make the same username as the database is entitled, for convenience.
11. Hit the (tab) key or click in the password box and assign the user a password
12. Click the box to the right entitled "Create User"
13. The MySQL Account Maintenance window now responds with "Account Created" and the sub-title "Added (username) with the password (pass you assigned)
14. Click "Go Back" one more time
15. Now for the final (and MOST often overlooked step in the entire process - Adding the new user to the database. Scroll down to the 3rd section entitled "Add Users To Your Databases"
16. Note the dropdown dialog boxes just under the title of the 3rd section. 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.
17. Now click the down arrow for "Database" and select the database you created in Step 5.
18. Ensure that the "Privileges:" dialog boxes have just ONE box checked (unless instructed by your developer/hosting provider) - that of "ALL"
19. Below all the dialog boxes in this 3rd section, click on the button entitled "Add User To Database"
20. MySQL Account Maint returns "Account Added to Access List" with the sub-title "Added user (your user) to the database (your database)
21. Your finished You can use your new database with any script
