In a nutshell:
To set up and use a database, it's basically a 3-step process. First, you have to create the database. Then you have to create a user. Lastly, you add the user to the database. This is all done out of CPanel from the MySQL section.
Better idea so you can understand the concept behind things, check out Bruce's link.