There are several steps involved in creating a new database but the wizard tool available in cPanel makes the entire job extremely easy. By creating your own database this way you can easily do a manulainstall of various scripts on your hosting and configure them to share this same single database.
The first step in the process is to locate the database wizard tool. If you can find the section of your cPanel dealing with databases it should be one of the icons that you can find there.
Simply double click on the mysql database wizard icon to start the install. Note that if your version of cpanel doesn't have this icon then you will need to use the mysql databases option and perform each of the tasks one after the other from there instead of having the wizard walk you through all the steps automatically.
The first step in the process is to give your database a name.
Having entered a name for the database (I entered 'test') we then press the 'Next Step' button to create the database and move on to the second step - to create a user that we can give access to the database.
Simply enter a user name and enter the same password twice and press the 'Next Step' button to continue. Note that your password should contain a combination of upper and lower case letters and numbers so that the password strength indicator shows green in order to ensure the security of your database.
The third step is to give your new user all priveleges relating to the database.
The fourth and final step is even easier than the preceding ones. Simply click on the 'Return to Home' link as you have now finished setting up the database.
This article written by Stephen Chapman, Felgall Pty Ltd.