Setting Up a MYSQL Database

Step 1 - Name your new database then click on "create database". Write down the database name.

Step 2 - Create a new user for your database and enter a unique password. Write down the username password and database name. Then click on "Create User"

Step 3 - Select the new user and the new database from the drop down list, where it says "Privileges" make sure that check box next to "All" is checked.

Step 4 - Click on "Add user to database"

Step 5 - Go to phpMyAdmin to install the SQL tables.

***NOTE*** Your mysql username and database name will be preceeded by the host account username. For example if you created a database with the name "r2b4" Cpanel adds the acount name to the username and db name. So your database name becomes "accountname_r2b4" and the same goes for your database username, only the password does not have the account name. (The account name is the user name you use to login to cpanel)