The easiest way to do this is by going to the MySQL Database Wizard under the Databases section in cPanel.
That will walk you through creating a database, creating a database user, setting a password, and then giving the database user permissions to the database all in one set of steps.