There are a number of functions you can use in cPanel, for managing your MySQL database users.
Create a User
You can easily create users, as shown in this video:
Delete a User
The next video demonstrates how you can delete a database user:
The following two videos show how to assign and remove a user from a given database: