Just about every major web application nowadays, whether it be Joomla, phpBB, ZenCart or any other application, requires the use of a database.  Every account on MoeDesignsHosting.com comes with access to a MySQL Database.  To start out using most applications, you will need to create both a Database and a User to access that database.

Step 1: Before performing any of these tasks you will need to login to your cPanel account and click on the 'MySQL Database' icon.

Create Database:

• Creating a database takes minutes, if you followed Step 1 you will be looking at a screen that, at the top, has the caption "Create New Database".
  
• Under that caption, there is a box with the label "New Database".  Enter a name for you new database in that box and click the "Create Database" button.
  
• You have now successfully created a new database!  If you are looking at a screen telling you that your database has been created, click the "Go Back" button to return to the previous screen.
  

Creating a User:

• At the same screen you started to create your database, if you scroll down a bit, you will see the "MySQL Users" section.
  
• Under that section there is the option for you to "Add New User", enter in a Username and Password in the two provided fields and then click the "Create User" button.
  
• You have not created a new user for your new database!  Now the only thing left to do is to link the user to the database.
  

Linking a User to a Database:

• If you are not looking at the initial screen that you were looking at when you created your database or user please follow Step 1 found above.
  
• So you have a database, and you have a user, all that is left now is to link them.
  
• Simply scroll to the bottom to where you see "Add User to Database"
  
• Choose the User that you created and the database you want to link to then click the "Add" button.
  
• In the next screen you will be asked which privileges you want the user to have. Normally you will just select the "All Privileges" option and click "Make Changes".  If you would like to know more about MySQL permissions you can do so by checking the MySQL Reference Manual
• You are done! Your database is created and has a user who can access it!
  

Add to Favourites
Print this Article