cPanel --> MySQL Databases
Will list your Database(s) and Database user(s)
Find the user you are interested in. Unattach it from the database. Delete it. Recreate it , writing down the password. Assign it back to the database with ALL Privileges.
Note: Your cPanel username is also a user for all your databases, with your cPanel password.