| What is a MySQL Database? MySQL databases allow you to store lots of information in an easy to access manner. The databases themselves are not easily read by humans. MySQL databases are required by many web applications including some bulletin boards, content management systems, and others. To use a database, you'll need to create it. Only MySQL Users (different than mail or other users) that have privileges to access a database can read from or write to that database.
There are two ways to create a MySQL database The easiest way to create a MySQL database is to use the MySQL Database Wizard built directly into the cPanel interface. The second way involves a few more steps, but does not require you to go through the wizard. Make your selection below:
Create A MySQL Database Using The Wizard
Create A MySQL Database Using The Wizard
1. When the page loads, enter the name of your new database in the "New Database" text box.
2. Next, click on the "Next Step" button.
3. You should see the following statement:
"Added the database YOUR_DATABASE_NAME."
4. Enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
5. Next, click on the "Next Step" button.
6. You should see the following statement:
"Added USERNAME with the password PASSWORD."
7. When the page loads you will see a two-column table. The top of the table provides a checkbox option "ALL PRIVILEGES" allowing you to create the database with all privileges, otherwise you can check each of the items in the two columns that you want to allow for your new database. The options include:
Note: Typically you may want to check the "All Privileges" option unless you want specific control over the user you are creating for this database.
8. Assuming you have either checked the "All Privileges" option or a combination of the options in the two columns, continue the wizard by clicking on the "Next Step" button.
9. You should see the following statement:
"User USERNAME was added to the database DATABASE."
10. When the page loads you will have three available options to choose:
Create A MySQL Database Manually
1. When the page loads, enter the name of your new database in the "New Database" text box.
2. Next, click on the "Create Database" button.
3. You should see the following statement:
"Added the database YOUR_DATABASE_NAME."
4. Click on the "Go Back" link.
5. When the page loads, you will see a table with your newly created database containing the following information, split into five columns:
6. In the "New User" section, enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
7. Next, click on the "Create User" button.
8. You should see the following statement:
"Added USERNAME with the password PASSWORD."
9. Click on the "Go Back" link.
10. Find the "Add User To Database" section. Select the user you created in Step 6 above from the "User" drop down menu. Then select the database you created in Step 1 above from the "Database" drop down menu.
11. Next, click on the "Submit" button.
12. When the page loads you will see a two-column table. The top of the table provides a checkbox option "ALL PRIVILEGES" allowing you to create the database with all privileges, otherwise you can check each of the items in the two columns that you want to allow for your new database. The options include:
Note: Typically you may want to check the "All Privileges" option unless you want specific control over the user you are creating for this database.
13. Assuming you have either checked the "All Privileges" option or a combination of the options in the two columns, continue the wizard by clicking on the "Make Changes" button.
14. You should see the following statement:
"User USERNAME was added to the database DATABASE."
15. Click on the "Go Back" link.
16. You should now see the user you created in Step 6 above in the "Users" column. |
Quick Navigation
Search
Client Area
