to setup a database in cPanel follow these steps
1. Load up cPanel
2. goto MySQL® Databases
3. Create a Database
3.1 find "New Database: " (in the 'Current Databases' section) and type the database name and click Create database
for this example i am going to use "MyDatabase"
the Next screen should say
SIDE NOTE: on my account the database is prefixed with the domain name ie MyDome_MyDatabase Keep note of this
3.2 Click Go Back
4. Now Create the user account
4.1 goto the 'Current Users' section
4.2 Enter a username and password
(for this example i am going to use User:User and Password: Pass)
4.3 click Create User
you should see the following screen
SIDE NOTE: on my account the username is prefixed with the domain name ie MyDome_user, the password isn't, Keep note of this
4.4 Click Go Back
5.0 setup access
5.1 goto Add Users To Your Databases section
5.2 change user to 'user' (in my case MyDome_user)
5.3 change database to 'MyDatabase' (in my case MyDome_MyDatabase)
5.4 under Privileges: select ALL (you can change this later but for testing use all)
5.5 Click Add User to Database
you should see a screen like this
So
User:MyDome_user
pass:password
database:MyDome_MyDatabase
host:local
i hope that helps